Forum Discussion
Scatter Diagram Date on X - Axis Randomized
Hi Slavi ,
I have found the problem,if you use Risk 1,2...as Y-Axis,it will sort as the following order: Risk 1,Risk 11,Risk 12,Risk 13...etc, as it was a text format,that is why it will show as below:
So the best choice for you is to change the "name" column into a whole number type using a dax expression as below:
Column = SUBSTITUTE('Table (2)'[Name],"Risk ","")Finally,you will see:
For the related .pbix file,pls click here.
Best Regards,
Kelly
Community SupportHi Slavi ，
I found that in the X-Axis,you are using date Hierarchy,pls choose date instead of Hierarchy as showed below:
As in here,I choose "Date" in X-Axis,they are ordered acending from left to right.
Best Regards,
Kelly
Hello v-kelly-msft and thank you for your response,
Unfortunately, for some reason this does not work for me. I even made a similar graph to yours but the result as you can see from the picture bellow are not what you'd expect. It starts of from 2018, then it goes to 2019 and then to 2018 again.
- v-kelly-msft
Hi Slavi ,
Show me part of your sample and remove the confidential ones,I will test for you.
Best Regards,
Kelly
