cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper I

Bar chart percentage of total

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.

1 ACCEPTED SOLUTION
Solution Supplier

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

If yes, then please mark my post as a solution!

Thank you,
Vishesh Jain

Proud to be a Super User!

2 REPLIES 2
Super User

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
Solution Supplier

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

If yes, then please mark my post as a solution!

Thank you,
Vishesh Jain

Proud to be a Super User!

Announcements

Fabric certifications survey

Certification feedback opportunity for the community.

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors