cancel
Showing results for
Did you mean:
Highlighted
Regular Visitor

## Ordering Clustered Column chart on Legend and Value

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

1 ACCEPTED SOLUTION

Accepted Solutions
Regular Visitor

## Re: Ordering Clustered Column chart on Legend and Value

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.

3 REPLIES 3
Regular Visitor

## Re: Ordering Clustered Column chart on Legend and Value

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.

New Member

## Re: Ordering Clustered Column chart on Legend and Value

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

Regular Visitor

## Re: Ordering Clustered Column chart on Legend and Value

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