Bar chart percentage of total

[Carrhill]

Hi, 

I know there must be a quick fix but I'm new to this (feel free to laugh!)

Blue bar = Count of Total Cases Opened

Green bar = Count of Total Cases Opened where the Due Date is not Blank (I created this column using a measure)

Problem is I want to show the green bar as a percentage of the blue bar.

Thanks for your help!

[Anand24]

Hi @Carrhill ,

You just need to create a % to total calculated measure and pull it to the bar chart.

PFA .pbix with solution.

You just need to replace the calculated measure here with appropriate column/measure name from your report.

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[visheshjain · Accepted solution]

Hi @Carrhill ,

You can define a measure, calculating the percentage and then format the measure as a percentage.

Then from the formatting pane of the visual, you can turn on the data labels and in the values section change the display units to none.

Ideally, I would not recommend having percentages and actual values in the same visual as they will not show the acutal bar, since percentages are mere decimals compared to the whole value and I do not think that you can have Numbers and Percentages both as data labels.

Here is an example:

Even though the sales are nearly 30 %, they only show a small line compared to the whole bar.

Hope this helps and if it does please kudo it and mark it as the solution as it helps others reach the solution faster.

Thank you,
Vishesh Jain