Forum Discussion

computhomas's avatar
computhomas
Regular Visitor
4 years ago
Solved

Display values as separate non-summarized dots along a time axis

I tried to do a visualisation which sounded easy but seems to be impossible with built-in tools - or I'm just not finding the right settings.

 

I have a data set containing items that have a numerical score and a transaction date.

Example below:

 

IDDATESCORE
12022-03-0145
22022-03-0170
32022-03-0130
42022-03-0260
52022-03-0350
62022-03-0320

 

What I wanted to display is some kind of plot that has the date on the x-axis and displays a point for every entry according to the score (0-100) on the y-axis.

 

So basically something like this:

 

Unfortunately I can't find a solution for that which doesn't summarize the score and displays the single values.

 

Any hints?

 

Thanks

 

Thomas

 

Need Help

8 Replies

      • Zaforin's avatar
        Zaforin
        New Member
        10 months ago

        It's crutial to create a new Index column, giving you an unique number to each row. Then you can use this column into the Legend field for the scatter visual. Worked for me.

        So, nothing in Values, X Axis with dates, Y axes with your selected field, and Legend with this Index column. If this doesn't work, then it's probably matter of fields format. 

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi computhomas ，

     

    Please configure the fields as shown in the screenshots.

    If this doesn't work for you or I misunderstand your needs, please consider sharing more details about it. And it would be great if there was a sample file without any sensitive information here.

     

    Best Regards,
    Community Support Team_Gao

     

    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

    • computhomas's avatar
      computhomas
      Regular Visitor
      4 years ago

      HI Gao,

       

      This only works when the Date Hierarchy is selected, like here:

       

       

      Then I get a result like this:

       

       

      Once I select the date itself, like here:

       

      I get this error:

       

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi computhomas,

         

        Please check whether the data type is the same as mine, if not, please modify it to the same. And try again.

         

        Best Regards,
        Community Support Team_Gao

         

        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

  • Mayank_Yavda's avatar
    Mayank_Yavda
    Icon for Resolver II rankResolver II
    4 years ago

    Hi computhomas ,

     

    Here is Scatter Plot - Categorical X Axis chart which will help to get categorical data or Date on X-axis and also on Y-axis with non aggregated values for ID (Just set the score value as "Don't Summarize" in Y axis value field). Hope this helps you.

     

    Scatter Plot - Categorical X Axis .PBIVizEdit.com

    Scatter Plot - Categorical X Axis .PBIVizEdit.com

     

     

     

     

     

     

     

     

    Download link for the custom visual file in this page

    https://pbivizedit.com/gallery/scatter-plot-with-categorical-data 

     

    This was made with our Custom Visual creator tool PBIVizEdit.com. With this tool,

    • anyone, irrespective of technical skills, can create their own visuals
    • 15 minutes to create a visual from scratch
    • opens up many additional attributes to edit (for e.g. labels, tooltips, legends position, etc)

    Give this a shot and let us know if you face any problem/errors.
    You can use the editor to modify your visual further (some modifications cannot be done in Power BI window and have to be in editor).

    Thanks,
    Team PBIVizEdit