Forum Discussion
Scatter Diagram Date on X - Axis Randomized
Hello everyone!
I am trying to create a Scatter (Bubble) Risk Diagram in Power BI, where the Probability of the risk is on the Y - Axis, the Date (Year, Month) is on the X - Axis and the Size of the bubble is the financial impact. I am experiencing dificulties with the Date. As you can see in the picture bellow, my dates are there as i want but they are not in order. I would like for them to be ordered first by year and then by month. I tried the Sorting option but it does not change a thing. Please help!
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
6 Replies
v-kelly-msftCommunity Support
Hi 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,
KellyHello 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
