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

Slavi's avatar
Slavi
Frequent Visitor
6 years ago

Hey v-kelly-msft ,

 

Nothing confidential on the last graph, really.

 

Here is my data:

v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
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

  • Slavi's avatar
    Slavi
    Frequent Visitor
    6 years ago

    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. 🙂