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.
Hello All:
Can you please help. In the latest desktop version of Power BI - 2.47.4766.542 64-bit (June, 2017)....
There is no longer the ability to sort ascending/descending in the Clustered Horizontal or Vertical charts.
This existed in the previous versions.
In this version, upon clicking on the three dots on the top right; there is no option for 'sort'.
Can somebody please help. What am I doing wrong
Thanks and best regards....Adi
Hi @AdiAsavaid,
Based on my test, the sorting option is remain in Power BI desktop June release.
But if you didn't add any field into Axis section of the clustered chart, the Sort option would be invisible.
Best regards,
Yuliana Gu
Hello Yuliana:
Many thanks for your prompt response.
Yuliana, unfortunately in my case I have Axis and Value and no Legend.
I am graphing the data of a simple Frequency column.
My data contains 300 rows and 1 column with cell values between 1 thru 5.
The measure is countrows and graph broken out by values.
Want to sort by the countrows rather than by the valid values.
Any ideas? Thanks and best regards....Adi
Hi @AdiAsavaid,
This time I could replicate your scenario. I assume that the data type of that column whose cell values are available between 1 through 5 is whole number. If that is the case, please change its data type to text, then, you can see the sort option in chart visual.
Best regards,
Yuliana Gu
Hello Yuliana:
Once again many thanks for taking the trouble to review my issue and helping me with this.
Yes, changing to text works but is not practical in my case this there are other numeric computations to be done on the column data. Changing this to text would make other calculations not possible.
Also, we have more than 1,000 such columns in this case.
Any other ideas to solve this would be a great help; or is this a case of enhancement request to MSFT-Power BI desk.
Thanks and best regards....Adi
Counts | Count% | Sum | Sum% | |
1 | 15 | 5.0 | 15 | 1.3 |
2 | 39 | 12.9 | 78 | 6.9 |
3 | 49 | 16.2 | 147 | 13.0 |
4 | 105 | 34.7 | 420 | 37.0 |
5 | 95 | 31.4 | 475 | 41.9 |
303 | 100.0 | 1135 | 100.0 | |
Hi @AdiAsavaid,
How about creating a new column whose values are the same as the original Frequency column? And set this new column to text.
New column=Table_name[RelatedColumn]
An other option is to set bins. Also, you need to set the bin type to text.
Besides, I think you could submit this idea to Microsoft: https://ideas.powerbi.com/forums/265200-power-bi-ideas?query=multiple%20values%20into%20line%20chart
Regards,
Yuliana Gu
Hello Yuliana:
Many thanks for your suggestion of creating another 'text' column and yes this would work.
However, this is not a practical solution in my case for the following reasons:
Given the sheer volume this would not be a pragmatic approach.
I will take your suggesttion and submit it to Microsoft.
Once again, many thanks for your time and effort you took to help me.
Best regards....Adi
Hi @AdiAsavaid,
Thanks for sharing your ideas. Your feedback is very valuable to improve the level of our products and service. If the feature request you submitted is mentioned by many users, product team will consider adding it to future release.
Best regards,
Yuliana Gu
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 |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |