Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am sorting a table using a Rankx Column,
When i sort Descending, it works perfectly as below..
Ranking is numbered 4 through to 1 descendding.
But when i change the visual to sort Ascending
Ranking starts at 2 and there are two number 2's and no number 1
The data hasn't changed.
Any idea why sorting the visual differently causes this?
I am just changing the visual sort from descending to ascending, no change to filters or measures.
Is this a bug ??
Solved! Go to Solution.
Hi @Anonymous ,
Due to the connection mode and Power BI Desktop version, I cannot access your .pbix file.
Is your formula the same as mine?
If you cancel the aggregation of the [Units] column, is the sorting result correct?
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Due to the connection mode and Power BI Desktop version, I cannot access your .pbix file.
Is your formula the same as mine?
If you cancel the aggregation of the [Units] column, is the sorting result correct?
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Linonel,
THANK YOU !!
You are right, its the aggregation causing the problem. I moved this from the RANKX to a seperate measure and now it works perfectly.
@Anonymous
Can you share the measure that you have used for ranking?
Better if you could a sample PBIX file to check further.
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
I have discovered that the visual diplays correctly if the data and visual are in the same PBIX.
When it displays incorrectly is when the data is in one PBIX and the visual is in another PBIX connected via a 'live connection'
Links to the two files are below:
https://1drv.ms/u/s!AtoYZpsBxPqIhsJuAbYU7VBgpRe_Ng?e=hIksyt
https://1drv.ms/u/s!AtoYZpsBxPqIhsJt7dOyiJniIrDUFQ?e=Zt1y2a
I have checked that the DAX query is the same for both.
Thak you, appreciate your help
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |