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

[computhomas]

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:

ID	DATE	SCORE
1	2022-03-01	45
2	2022-03-01	70
3	2022-03-01	30
4	2022-03-02	60
5	2022-03-03	50
6	2022-03-03	20

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

[Mayank_Yavda]

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

[Anonymous · Accepted solution]

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]

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]

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

[computhomas]

Thank you, I didn't realize I had to set the lead_score to Sum again.

[amitchandak]

@computhomas , just a though - Scatter visual with X-axis as date, Details as ID , score as value

[computhomas]

@amitchandak I see no details in the scatter visual.

And just using the above leads to