Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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!
Solved! Go to 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
Proud to be a 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 !!! |
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
Proud to be a Super User!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
90 | |
88 | |
83 | |
64 | |
49 |
User | Count |
---|---|
127 | |
108 | |
87 | |
70 | |
66 |