Forum Discussion
Donut chart
Hello,
Can someone please help with his one? I hav budget and current total. Also I calculated remaining amount and I would like to show this remainer amount in my donut chart in procentage....but It seems like I am doing something wrong.. When i drag ma metrics into the chart , it showing only 100%. What do I need to do to show the correct amount?
Also, is the a way to create a similar 3 fields in Power Bi to show the balance, current spent amount and diffrence??It not a slicer , i used the matrix chart and just made smaller and formatted to get something similar but i though i would ask here if I can something better to achieve the same result. Thank you!!!
5 Replies
Hi Just2431
To get the desired donut you need 2 measures :1. Your actual
2. Act_budget_diff = [budget]-[Actual]
3. For the percent in the center you need a measure:
Act_budget_% = divide([Actual],[budget])Result :Note that it is a card for percent grouped with the donut
pbix is attached you can follow my steps
Regarding the second question, I didn't understand what you meant there, but I guess the logic is similar.
If this post helps, then please consider Accepting it as the solution to help the other
members find it more quickly
Hi! Thanks for the response, i still dont understand how do you get the donut with the "space" ....I tried diffrent things with diffrent measures and i cant get the result.
oh I see,ok undesrtand now the process of creating such donut but my percentage doesnt show.. I created a new measure for the % but id doesnt show as percentage .I attached snipet to show it. Thank yu for your help!
