Forum Discussion
sort by index order
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.
Thanks,
i made an power bi example with dummy values. In this example it don't allow me to sort the other columns by the index, I didn't get the reason.
https://we.tl/Vo7fNwZPxK
Thank you for your help,
Mariana
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.
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"
This is THE KEY point. You have to *SELECT THE COLUMN YOU WANT SORTED* and then SORT BY INDEX FOR THAT COLUMN
