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.
Hi All - I am trying to create something like below. A stacked bar chart that shows the top 10 sum value vs the rest sum value. The top 10 selection will be dynamic because there's a time period filter applied.
I tried to create a rank for each row within the selected period, then also created a new measure - Category top 10 based on the rank but it's not working because I can't drag this new field to seperate the top 10 portion from the bar chart. Any idea?
My data looks like this:
ID Amount Date
1 3 3/1/2021
2 65 3/14/2021
3 234 2/1/2021
4 345 2/5/2021
5 564 6/3/2021
6 64 7/3/2021
7 45 8/3/2021
8 11
Solved! Go to Solution.
@windynan
Check the attached file.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@windynan
You use this technique to achieve TopN + Others
https://blog.gbrueckl.at/2019/05/power-bi-dynamic-topn-others-with-drill-down/
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi Fowmy - this is not what I am looking for. The link you mentioned are not stacked bar chart. I am looking for a way to stack top N and others amounts in one bar, not seperate bars.
@windynan
Check the attached file.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thankssss!!! This is exactly what I was looking for.
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 |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |