Dynamic Axis on chart?

[Anonymous]

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!

[dax]

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.

[sturlaws]

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