Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have a bar chart that counts the number of cases our business unit receives. As an aside, we also have different Events (at any random day) which may influence the number of cases received. I'd like to have a marker (or some visual) to quickly identify when an Event occured. How would you suggest to go about this? Desired outcome is below (Event markers are in orange).
Thanks in advance for your help!
Solved! Go to Solution.
My suggestion is to use the Combo Clustered Line Chart. This can be a 1 or 0 or actual Event Count.
Create a measure to Count your Events. Put this as your Line. Something like this.
Then you can change line stroke width to 0, and change the Marker per your requirement.
Hope this gives you an idea to work with.
Regards,
My suggestion is to use the Combo Clustered Line Chart. This can be a 1 or 0 or actual Event Count.
Create a measure to Count your Events. Put this as your Line. Something like this.
Then you can change line stroke width to 0, and change the Marker per your requirement.
Hope this gives you an idea to work with.
Regards,
Thank you! I'm curious if there is a mehod to display the name of the event when a user hovers over a marker?
Yes, you can use the Tooltip functionality.
Drag the field or fields you want to display into the Tooltip well.
Other option is to create a custom Tooltip Page. Search Youtube and you will get all the info you need and much better explanation than I can do here.
Regards,
@datapal04 ,
To achieve this you have to use line and stacked column chart and then in the Line y axis you have to use event metrics, then you have to enable markers under marker section then reduce the line stroke under line properties.
Now you may get the expects result.
Thanks,
Please share sample data.
Thanks,
Here you go. There 2 tables: cases by day and dates for Events.
Date | Case Numbers | DayType |
2022-06-13 0:00 | 180 | Weekday |
2022-06-14 0:00 | 252 | Weekday |
2022-06-15 0:00 | 269 | Weekday |
2022-06-16 0:00 | 244 | Weekday |
2022-06-17 0:00 | 269 | Weekday |
2022-06-18 0:00 | 129 | Weekend |
2022-06-19 0:00 | 96 | Weekend |
eventname | eventdate |
Event 1 | 2022-06-14 |
Event 2 | 2022-10-19 |
try this,
then,
make line stroke to 0
Thanks,
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
69 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |