Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I am trying to create a pie chart that displays only the top major causes, where each major cause has a fixed category proportion, So I would like to show the top major causes without affecting the category proportion percentage, when I tried doing the GT% of the total, the percentages changed, it changed according to the top N only, Like it is considering only the top major causes to be 100%.
Can anyone please help me with this problem?
Solved! Go to Solution.
Hi, @jospradil ;
You should create a measure to calculate the percentage.
Measure = SUM([ Sales])/CALCULATE(SUM(financials[ Sales]),ALL(financials))
then set it.
The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @jospradil ;
You should create a measure to calculate the percentage.
Measure = SUM([ Sales])/CALCULATE(SUM(financials[ Sales]),ALL(financials))
then set it.
The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for your reply! I am trying to create a pie chart according to the count of crash_key; the numbers and percentages are shown in such a way that it counts the crash_key (The crash_key looks like 2017334512). My dashboard is where we select an intersection ID; each intersection ID has a category description like
undivided high-speed partial stop, etc. Now in this category description, I am trying to calculate the category proportions for each factor of the crash (Like Major Cause, Environmental Conditions, etc.); I tried using your method by putting count instead of sum; this is what my measure looks like:
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |