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

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

Hi Slavi ,

 

Show me part of your sample and remove the confidential ones,I will test for you.

 

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