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,
I have a chart that looks like the following:
I'm trying to show the top 5 per month (changing month to month), but the visual filter is only able to rank top 5 for the entire period on the chart. Is there a quick measure I can throw together to drop into the legend field here that would allow for a different 5 for each month?
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi,
I am not sure how much i can help but i would like to try. Share the download link of the PBI file.
@jdriscoll , Simply use TOPN measure on legend
Sumx(keepfilters(TOPN(5,allselected(Table[Fruit]), calculate(Sum(Table[NumSales])), desc)), calculate(Sum(Table[NumSales])))
refer to check both TOPN and Window
Dynamic TOPN using TOPN/Window and Numeric parameter: https://youtu.be/vm2mdEioQPQ
Thank you for that. I tried it, but unfortunately the Legend field won't accept my new Top5 measure. See below.
This is the same issue I've been having with other measures I tried to create and use for the Legend.
Hi,
You may download my PBI file from here.
Hope this helps.
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 |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |