Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
gunicotra
Helper II
Helper II

Scatter plot with Date in X axis

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:

EventDateIntensity
event115/05/202220%
event230/05/202250%
event315/04/202280%
event431/12/202290%


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%). 

gunicotra_0-1645629255604.png

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

gunicotra_1-1645629614394.png

 

Can anyone give some hints?

Thanks

G



 

1 ACCEPTED SOLUTION
Mayank_Yavda
Resolver II
Resolver II

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

View solution in original post

4 REPLIES 4
Mayank_Yavda
Resolver II
Resolver II

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

Thanks Mayank_Yavda! It works percfectly 🙂

amitchandak
Super User
Super User

@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

Hi amitchandak!

yes I tried but this seems not to be working:

gunicotra_0-1645632217731.png

 

gunicotra_1-1645632259158.png

 

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.