Ordering Clustered Column chart on Legend and Value

[mukhan169]

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.

[mukhan169 · Accepted 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.

[Anonymous]

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])))

---

[mukhan169]

@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.