cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mukhan169 Regular Visitor
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.

Sorting 2.PNG

Thats how Chart should look like. Here is how the field look like

Chart Settings.PNG

Thanks in advance for your help.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
mukhan169 Regular Visitor
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
mukhan169 Regular Visitor
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.

looraainne New Member
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])))


 

Highlighted
mukhan169 Regular Visitor
Regular Visitor

Re: Ordering Clustered Column chart on Legend and Value

@looraainne 

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