Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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 measure" "2- name of mesure" ....."12-name of mesure"
I have created one new column that is only the number of measure "1","2",...,"12" and sorted by this new column and added a index to order the data. However in my graphs appears every time in other orther..could you please help me?
thanks in advance.
Solved! Go to Solution.
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
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.
Hi @Sea_and_Anne,
How do you use the “sort by column” feature in Power BI Desktop? Firstly, in Query Editor, please add a index column to your table as shown in the following screenshot.
After clicking “Close & Apply”, in Report view, choose the column dragged into Axis in Fields panel, then click “Sort By Column” and choose Index under Modeling ribbon.
Then check if your visual displays as expected.
Thanks,
Lydia Zhang
Hello,
Thank you for the solutions.
I tried both but i didn't got the expected result.
I've sorted by index in "Data" window but when i go to the report the "sort by" button is not active.
Could you please help solving this issue?
Thanks in advance,
🙂
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
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
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
This is THE KEY point. You have to *SELECT THE COLUMN YOU WANT SORTED* and then SORT BY INDEX FOR THAT COLUMN
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:
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
89 | |
84 | |
77 | |
49 |
User | Count |
---|---|
143 | |
140 | |
109 | |
69 | |
55 |