Changing row order in table

[Justas4478]

Hello I am trying to find a way how to change order of the rows in the table. This is the table for example. 

None of the sorting options give me result I need. I dont have access to the Transform Data since I use live cube connection. So is there way that maybe using measure I can specify the order that I want these rows to be in. The order that I am trying to get is: High street > shopping centre > retail park > shopping precinct > supermarket > factory outlet centre. Thank you.

[v-jayw-msft]

Hi @Justas4478 ,

Create a measure:

measure = switch(selectedvalue([type]),"High Street",1,"shopping center",2,....)

Add this measure tooltips and sort the visual by the measure.

Best Regeards,

Jay

[Justas4478]

The measure works. But I can't find a way how to add measure in the table as tooltips and not as values. Could you explain how to do it?

[v-jayw-msft]

Hi @Justas4478 ,

What visual you are using?

Best Regards,

Jay

[Justas4478]

I am using just a table visual.

[v-jayw-msft]

Hi @Justas4478 ,

My bad. Table visual doesn't have Tooltips field. You will need to add it to Values field.

Best Regards,

Jay

[Fowmy]

@Justas4478 

You can add another column that will be the sort order and for this column.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column

[Justas4478]

Unofrtunatelly I can't do that since my data is using live connection method and I am restricted to only be able to create measures. I cant create or add columns. Is there any other method available?