Forum Discussion

Slavi's avatar
Slavi
Frequent Visitor
6 years ago
Solved

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 ...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    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

v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
6 years ago

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