Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hey Guys!
I have created a donut graph and the % doesn't display the correct numbers. Whenever I try to filter it via names the % isn't right, while the sum is correct! I want it to display as 461/497 = 93%. Is there a step that I am missing out?
Thanks
Solved! Go to Solution.
Hi @ashish93 ,
Because you do not provide data table, I create a table for test.
1. below is my test table
Table:
2. create two measure with below dax formula
Measure = SELECTEDVALUE('Table'[Lead Target])-SELECTEDVALUE('Table'[Lead Generated])
Measure 2 = DIVIDE(SELECTEDVALUE('Table'[Lead Generated]),SELECTEDVALUE('Table'[Lead Target]))
3. add a Donut chart and Card chart with measure and field
Please refer the attached .pbix file.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hope the solutions helped you
Mark my/relevant post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Series
Hi @ashish93 ,
Because you do not provide data table, I create a table for test.
1. below is my test table
Table:
2. create two measure with below dax formula
Measure = SELECTEDVALUE('Table'[Lead Target])-SELECTEDVALUE('Table'[Lead Generated])
Measure 2 = DIVIDE(SELECTEDVALUE('Table'[Lead Generated]),SELECTEDVALUE('Table'[Lead Target]))
3. add a Donut chart and Card chart with measure and field
Please refer the attached .pbix file.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Pie /Donut charts may be not good for this purpose where you are chasing a target
Seems like you need a Gauge Chart here, will look better & relevant as well
Radial gauge charts in Power BI - Power BI | Microsoft Learn
Regards,
Ritesh