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.
Hey,
as I understand you want to sort one column by another column.
In the DataView select the column that you want to be sorted. Then choose from the "Sort by Column" Menu the proper column that contains the index.
Hope this helps
Thank you for the solution, I had already tried this but also didn't worked.
:)
Any other suggestion to solve this?
thanks in advance
- And you've confirmed that you're index or sort column data type is numeric?
- Hey,
it seems necessary that you provide a link to a simplified pbix-file that can be downloaded.
As we state, ordering one column by another column works in our scenarios, obviously this means that we are not able to reproduce this odd behavior in your scenario.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/Vo7fNwZPxKThank 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.
