Bar labels to be positioned below (or top, left, right) and not only on a separate Legend

Jorge Olmeda

It would be needed to have the possibility to position label names below the corresponding bar and not only as separate legend.

Desired as below

Currently only possible like below

Thanks.

Benjamin Arnulf-Oracle

I can do it. Are you asking for something different?

Gabby Rubin-Oracle

@Jorge Olmeda I guess your question is how to color your bars without changing the grain, which will cause the gaps that Ben has in his image. The best solution for this scenario is to use a stacked chart.

Jorge Olmeda

Thank you @Benjamin Arnulf-Oracle @Gabby Rubin-Oracle for your quick responses.

I mean I can do that as you say as long as I use dimensions, but I am talking about facts here. In my sample pictures, "FY22", "FY23", "NS 3YA", etc. are measurements I have as custom calculations. not as dimensions.

Gabby Rubin-Oracle

Yes, measures are a bit more tricky. You can do it easily without the color (image 1), but if you want color, you need to use conditional formatting for the measure (image 2).

Jorge Olmeda

Hi @Gabby Rubin-Oracle,

Thank you for the tip, sorry I didn't know about that possibility of adding "Value labels" as Category. Coloring would be nice without having to setup conditions there 😀

Regards,

Jorge

Jorge Olmeda

Hi again,

Additionally in this case wouldn't be able to add any parameters in measures to create dynamic names like "Sales 2024".

Thanks.