Forum Discussion
Changing row order in table
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.
7 Replies
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-columnUnofrtunatelly 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?
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
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?
