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.
I have clustered Column chart. The legend is Year and value is a measure. The year table has index column so I can order the chart by year. The issue I am having is that its in not sorting the value by heighest of the year. So first I want to sort by year and then the highest value of that year.I think Following will help.
Thats how Chart should look like. Here is how the field look like
Thanks in advance for your help.
Solved! Go to Solution.
Ok the solution was much simpler then I thought. I ended up creating a measure like this
CPV For Maximum Selected year= CALCULATE([Level2IPTV]| FILTER(Table|Table[Field]=max(Slicer table[Slicer Field])))
and then drag it to "tooltips" and Set the order by it. and you get your desired result.
Ok the solution was much simpler then I thought. I ended up creating a measure like this
CPV For Maximum Selected year= CALCULATE([Level2IPTV]| FILTER(Table|Table[Field]=max(Slicer table[Slicer Field])))
and then drag it to "tooltips" and Set the order by it. and you get your desired result.
I am having trouble understanding the formula. Maybe you could show a pic of the table and column names or provide the sample file? I need this exact same function as well. Thank you!
@mukhan169 wrote:CPV For Maximum Selected year= CALCULATE([Level2IPTV]| FILTER(Table|Table[Field]=max(Slicer table[Slicer Field])))
@Anonymous
[Level2IPTV] is the measure. and then I am filtering on the table that is creating the slicer. If you need the same measure let me know about your slicer table name and your measure name and i will try to help you to the best of ability.
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 |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |