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

The 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.

Reply
ashish93
New Member

percentage

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?

 

ashish93_0-1672731152514.png

 

Thanks

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @ashish93 ,

Because you do not provide data table, I create a table for test.

1. below is my test table

Table:

vbinbinyumsft_0-1672802078648.png

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

vbinbinyumsft_1-1672802197766.png

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.

View solution in original post

3 REPLIES 3
ribisht17
Community Champion
Community Champion

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

 

Anonymous
Not applicable

Hi @ashish93 ,

Because you do not provide data table, I create a table for test.

1. below is my test table

Table:

vbinbinyumsft_0-1672802078648.png

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

vbinbinyumsft_1-1672802197766.png

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.

ribisht17
Community Champion
Community Champion

@ashish93 

 

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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!