Forum Discussion

Patricio479's avatar
Patricio479
Frequent Visitor
1 year ago
Solved

Scatter Chart to check trends

Hello Guys! I'd like to replicate (or at least be close enough) to the below excel chart I have prepared using the scatter chart. Basically, its a number of activities with a certain finish date in ...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi, Patricio479 

    Currently Power BI doesn't exactly replicate the visual objects you need, but you can check the image below to see if it matches your needs.


    Method:
    Unpivot column to trans your data

    Get this

    Create a date table and create the relationship with raw table.

    Date = CALENDAR(DATE(2025,1,1),DATE(2025,7,2))

    Creat a line chart



    If it doesn't match, you can submit an idea for here and the product team will take note of such a need.

    Related Link: New tab (powerbi.com)

    Best Regards,
    Yang

    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know.
    Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

     

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi, Patricio479 

    Yes, that's what I meant by not being able to reproduce exactly, it doesn't work when the same date corresponds to multiple values, no matter which field is used as the X axis, you will face a one-to-many mapping situation, which is not supported in Power BI. You can submit an idea for here and the product team will take note of such a need.

    Related Link: New tab (powerbi.com)

    Best Regards,
    Yang

    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. 
    Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum