Scatter plot with Date in X axis

[gunicotra]

Hi to all,

I have realized two measures that gives me the date at which some events occur and the intensity. The table appears like this:

Event	Date	Intensity
event1	15/05/2022	20%
event2	30/05/2022	50%
event3	15/04/2022	80%
event4	31/12/2022	90%

I would like to plot every event on a scatter graphic with Date in X axis and Intensity in Y axis. I tried with standard scatterplot visual but the only thing I get is some uncomprehensible "numbers" on X axis and no Date at all (as for the Intensity it is correct that in Year 2021 all event are 0%). 

the settings a the following (sorry it is in italian!)

Can anyone give some hints?

Thanks

G

[Mayank_Yavda · Accepted solution]

Hi @gunicotra 

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. Hope this helps you.

Scatter Plot - Categorical X Axis .PBIVizEdit.comScatter 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

[gunicotra]

Thanks Mayank_Yavda! It works percfectly 🙂

[amitchandak]

@gunicotra , I see a measure on x-axis, Have tried putting the date on that?

refer if needed

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-scatter

[gunicotra]

Hi amitchandak!

yes I tried but this seems not to be working: