CODEWITHSUNDEEP
powerbi
Double_O_Kevin
Double_O_Kevin

Reputation: 31

Power BI Tabular Sort Order

Test driving MS Power BI Designer. In the Tabular visualization I can't find way to maintain data source order. I have a specific order I want a text field to be in. It is sorted that way in query but report only allows asc/desc order. Don't want to put 01,02,03 in text field. Also don't want to include "order" field in the visualization. (That would work if I could "hide" field though). Any ideas?

Upvotes: 3

Views: 1073

Answers (2)

Casey H
Casey H

Reputation: 23

There's a way to do this in Power BI Desktop. Check this video at about 10:50.

https://youtu.be/d2bZpNZ6uIA?t=10m50s

You'll need to create another column of number values to tell it what order to sort the text values in. You can do that with "Enter Data" if it doesn't already exist.

Upvotes: 1

Lukasz P.
Lukasz P.

Reputation: 2229

This is a capability that is on the roadmap. If you use Excel, you can see the 'sort by' option in Power Pivot. The same capability will come to Power BI Designer, but it's not there yet.

Appreciate your using Power BI, -Lukasz

Upvotes: 1

Related Questions