Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I am trying to create donut chart with percentage view but its not working for me.
The total receipt is 4, measure I am using -> total receipt = Sheet1[Receipt Initiated After Effective Date]+Sheet1[Receipt_rest]
where 1 is receipt initiated after effective date, measure I am using->
and 3 is Receipyt rest, measure I am using ->
Solved! Go to Solution.
Hi @Anonymous ,
Do you wanna show as below:
If so,remove the total measure from the donut field:
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Hi @Anonymous ,
Do you wanna show as below:
If so,remove the total measure from the donut field:
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Hi @sayaliredij,
Still not clear.
Actually I am fairely new to powerBi
Is there any option here to attach my dashboard?
Can you add pbix file (after removing sensitive data) at some dropbox location?
Proud to be a Super User!
You can not add in Forum but you have to add using drop box or one drive.
Proud to be a Super User!
As these 3 attributes are separate measures. It is not possible to fit them in a single donut. But you can do the following
1. In your main table, add column "category" and you can categorize each receipt using this calculated column
2. Then you just need to create one measure eg. COUNTROWS(Tab)
3. use this measure for donut chart and in the legend - specify category
Thanks,
Sayali
If this post helps, then please consider Accept it as the solution to help others find it more quickly.
Proud to be a Super User!
@Anonymous , Donut chart showing % , is that calculation not correct. I doubt you can display 1/4, 3/4 etc
Hi @sayaliredij ,
Can you help me with the below -
1. In your main table, add column "category" and you can categorize each receipt using this calculated column - What would be the dax formula?
2. Then you just need to create one measure eg. COUNTROWS(Tab) - Measure as in?
I dont know how exactly the data look like
But I could imagine something like this
Regards,
Sayali
Proud to be a Super User!
I used the following data
Category has formula as below
Please check if this works. Make sure you have else condition in the formula
Regards,
Sayali
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |