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 ,
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 ?
Solved! Go to 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
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.
@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
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |