Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
90 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
99 | |
88 | |
72 | |
60 | |
59 |