Scatter Diagram Date on X - Axis Randomized

[Slavi]

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!

[v-kelly-msft]

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,
Kelly

[Slavi]

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

[Slavi]

Hey @v-kelly-msft ,

Nothing confidential on the last graph, really.

Here is my data:

[v-kelly-msft · Accepted solution]

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

[Slavi]

Thank you @v-kelly-msft! It did work. For my primary data i didn't have numerated Risks as names, so i inserted a index column for the Names and then created another Excel Sheet where each name was given a unique number and linked them. This worked and now everything is in order. 🙂