Forum Discussion
Sea_and_Anne
9 years agoHelper I
sort by index order
Hello, I want to sort the data in the graphics by the index number, but it never appears in the correct way. C So i have a column with the measures that are in this formula " 1 - name of measur...
- 9 years ago
Hmm,
maybe I'm still not getting the point ...
A simple bar chart looks like this:
I'm sorting the column Measure by Column1, these are the steps
- select the data tab
- select the column: Measure
- "Sort By Column": choosing "column1"
I'm getting this:
Finally I'm applying a Visual Filter to avoid the Total Measure, this may be necessary, due to the fact that blank values (Measure: Total) are sorted before the measures that have a proper value in the column Column1
If this is not what you want, I guess you have to explain the outcome a little more.
Two questions:
What kind of visualization are you using (in my example I'm using "Clustered Bar Chart"
and what release of Power BI Desktop are you using.
austinsense
9 years agoImpactful Individual
If your index has the data type "Text" then it will sort like this ... { 1, 10, 11, 2, 3, 4 ... }
Two options to fix it:
- Change the data type to "Whole Number" - currently it might be "Text" or "Any"
- Keep the data type of the field "Text" but make the records look like this { 01, 02, ... 11, 12 } - that will sort correctly as text