How to show type to date data of X axis when drilling down/up on line chart on a card ?

[Anonymous]

Hi ,
I have sales data depicted on a trend graph with a drill down option to the user. I want to show on card , what type of date data is presented on the X axis. Example : If data is drilled to quarterly, the card says "quarterly". If data is drilled to monthly , the card says "monthly", If data is drilled to weekly, the card says "weekly". etc.

In my case , I only want to show drill selections for Quarters, Months, weeks and Days.
I have illustrated the examples and attached them below.

How to show type to date data of X axis when drilling down/up on line chart on a card ?

[v-angzheng-msft]

Hi, @Anonymous 

If you just want to create a card to illustrate the type of the date, then you can save this step. We notice that the type of date is already displayed on the title of the line chart. If we want it to be as eye-catching as it is displayed on the card, then we just need to adjust the font of the line chart title.

We can even customize the column aliases by double-clicking on the field names.

If you insist that cards are what you need, then as @amitchandak  said, you can display data by quarter, by month, by day via bookmarks and buttons.

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Anonymous , I think you need to use bookmark and buttons not card

bookmark -https://blog.crossjoin.co.uk/2018/04/20/dynamically-changing-a-chart-axis-in-power-bi-using-bookmarks-and-buttons/
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive