how to give different sort order columns on one same label column

[Shaf_123]

Hi ,

I want to use same label column in different pages , for different visuals , if I am using sort by column on label column it is applicable to all the pages, I dont want that , I want to sort lable column based on different sort columns.

label column                          different sort orders columns

                

 

 currently I am using "sort L4"  as sort by column on label column"Inc Types L4" and created on bar chart on page-1

I need to create another matrix ,"Sort_Age" as sort by column on same label column  "Inc Types L4"  on Page-2

but I am unable to use different sort by column on different page either I can use Sort L4 or Sort_Age

so one of the page visual is getting wrong .

Thanks in advance for your help

[amitchandak]

@Shaf_123 , you can not have two sort columns. If you need then you need to copy the base column to

col , sort col1

col 2 = [col]

sort col2  = <some logic>

[Shaf_123]

but for 10 pages I have to create with difeerent sort orders I need to duplicate label columns 10 times , I dont want that,

do we have any other option that I can use at page level to sort  my same label column with different sort orders.

Thanks

[v-lionel-msft]

Hi @Shaf_123 ,

Great idea, but it can be achieved in current version(2.84.701.0 64-bit (August 2020)).

Please submit your idea .

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Shaf_123]

Hi Lionel Chen,

I have installed updated version as you mentioned, but it did not change the functionality  of the  sort by column option, 

I am facing same issue , I am of losing on of the page visual, if I select any one sort order column, it is still impacting the whole report,not working at page level.

Reuqest you to let me know, is there anything I am missing on this.

Thanks in Advance 

[v-lionel-msft]

Hi @Shaf_123 ,

😅I'm sorry, what I want to say is that the current (2.84.701.0 64-bit (August 2020)) version can not be implemented.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.