matrix problem with sorting

[Paulina_Przybyl]

Hi,

I fight with broplem with sorted by indeks. I would like to create part of P&L and I have to sort by indeks in matrix:

here is working, but i really have to hidden the indeks, even I put here:

is no working 😞 

[MrSujay · Accepted solution]

Hi @Paulina_Przybyl ,

 Select your table/Matrix visual (that can be sorted) and choose More actions (...). ( i.e. 3 dots.)

There are three options for sorting: Sort descending, Sort ascending, and Sort by.

Click on Sort ascending and again select sort by - Index.

Check the below screenshot.

Thanks,

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

[Paulina_Przybyl · Accepted solution]

Sure, it works but I have to hidden a Indeks column, middle time I found solution I sort by indeks and hide it use this option:

[Paulina_Przybyl]

Hi, on my data is not working, but I create other and is ok. For my data I used moreround as I send ahead

[Paulina_Przybyl · Accepted solution]

Sure, it works but I have to hidden a Indeks column, middle time I found solution I sort by indeks and hide it use this option:

[MrSujay · Accepted solution]

@Paulina_Przybyl  ok instead of hiding the Index column you can use this setting.

You need to go into the table/data view, click on the KPI column to be sorted, click "sort by column - Index"
and then also sort the Index column by Index. 

and here is your expected output in table/matrix visual.

Thanks,

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

[MrSujay · Accepted solution]

Hi @Paulina_Przybyl ,

 Select your table/Matrix visual (that can be sorted) and choose More actions (...). ( i.e. 3 dots.)

There are three options for sorting: Sort descending, Sort ascending, and Sort by.

Click on Sort ascending and again select sort by - Index.

Check the below screenshot.

Thanks,

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