Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
Carrhill
Helper I
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.

Carrhill_0-1646738212247.png

 

 

Thanks for your help!

1 ACCEPTED SOLUTION
visheshjain
Solution Supplier
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.

Screenshot (306).png

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

Did I answer your question?
If yes, then please mark my post as a solution!

Thank you,
Vishesh Jain

Proud to be a Super User!



View solution in original post

2 REPLIES 2
Anand24
Super User
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.

PBI_SuperUser_Rank@1x.png  

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

Screenshot (306).png

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

Did I answer your question?
If yes, then please mark my post as a solution!

Thank you,
Vishesh Jain

Proud to be a Super User!



Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.