Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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,
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
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.
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,
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 🙂
@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:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
98 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |