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 all,
Need help to show percentage per cleaning type where x-axis is "Yearmonth" and Y-axis is "no. of order".
Kind regards,
Sahil Goyal
Solved! Go to Solution.
Hi,
I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
I hope the below can provide some ideas on how to create a solution for your datamodel.
Custom Label measure: =
COUNTROWS ( Data ) & " | "
& FORMAT (
DIVIDE (
COUNTROWS ( Data ),
CALCULATE ( COUNTROWS ( Data ), ALL ( 'Cleaning Type'[Cleaning Type] ) )
),
"#0.00%"
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
I hope the below can provide some ideas on how to create a solution for your datamodel.
Custom Label measure: =
COUNTROWS ( Data ) & " | "
& FORMAT (
DIVIDE (
COUNTROWS ( Data ),
CALCULATE ( COUNTROWS ( Data ), ALL ( 'Cleaning Type'[Cleaning Type] ) )
),
"#0.00%"
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi @goyalsa
Technically you can achieve your goal using a combo chart with 2 Y axes.
You can follow this tutorial:
https://bielite.com/blog/percent-data-labels/
From the side of effective Data visualization, the stacked chart is very challenging to read, and if you add more pixels of data, that will confuse graph readers even more.
Please see my blog post about this issue:
"Home experiments" and stacked bar graphs (madeiradata.com)
I highly recommend using small multiples instead of stacked charts and putting your percentages on a tooltip.
Something like this:
link to a sample file : Here
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
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 | |
87 | |
84 | |
68 | |
49 |
User | Count |
---|---|
131 | |
111 | |
96 | |
71 | |
67 |