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, hopefully someone can advise me with this!
I have 2 tables, a calendar table and a ticket table.
Calendar contains the field CleanDate
Tickets contains TicketID, DateCreated, HourCreated and the measure count(TicketID)
I have a very simple chart that looks at number of tickets raised over a period of time. This consists of count(TicketID)
as the values, and CleanDate as the Axis. I also have a date slider on the report so the user can see the number of tickets over a period of time.
What I want to do is if the user selects the current day, the axis goes from CleanDate to HourCreated. This will show the tickets created throughout the current day.
Is this possible?
Thanks for any help!
Hi JD09531,
I think you could add date and hour field in axis, then when you choose corresponding period, it will show coresponding period's value. If you want to get hour 's value, you could click "go to the next level in hierarchy" to see value of "Hour created"
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You can't change the axis like that based on the slicer value. You can add both date and hours to the x-axis of the visual, and manually drill down from date to hour. Or you can create two overlapping visuals, one with hours and one with date, and use bookmarks to switch between them.
cheer,
S
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 |
---|---|
112 | |
99 | |
82 | |
70 | |
63 |
User | Count |
---|---|
145 | |
111 | |
104 | |
84 | |
64 |