Forum Discussion
Advocate IIIsorting not working for clustered bar in latest version June 2017
Microsoft EmployeeHi 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
Advocate IIIHello 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 | |
- v-yulgu-msft
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- AdiAsavaid
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:
- There are about 1,000+ raw data columns and they vary depending on the statistical survey.
- And each of the columns need at least 2 computations if not more.
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
- v-yulgu-msft
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