How can I display 2 values in a clustered bar chart?

[Anonymous]

I'm using a clustered bar chart and I am trying to display two measures, one that shows $ this year, another showing % chg vs YA. I want the bar to be $ but I want the values to say $5M, 10% etc. Is there an easy way to do this?

[Syndicate_Admin]

Create a new measure and concatenate the two measures you need, giving the required format. Example:

MedidaCombinada = .MAX(Table[CampoTexto])&" "&FORMAT(SUM(Board[Medida1])/[Medida2],"0.0%")

then, go to the visual field settings > Data Label > Values > Field and put the "CombinedMeasure"

[Anonymous]

Hi @Anonymous ,

Currently Power BI don't support the customized label,  you can refer the method in the following threads as workaround to get it.

How to show detailed Labels (% and count both) for clustered column chart visualization?

Showing % for Data Labels in Power BI (Bar and Line Chart)

Best Regards
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.

[amitchandak · Accepted solution]

@Anonymous , You have to create a clustered line visual for that. Or you can add percent value to like visual.

For formatting, you can use the measure tool or formatting option mentioned here https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings

Format options