Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Good afternoon!
I have a dashboard:
It is based on daily data about sales in different channels. Visuals used in the dashboard:
I want to do the following: if the dashboard user selects some date range on the Tallan Calendar, the matrix visual displays sales for selected date range. If the user selects some of the options from MTD, QTD, YTD, the matrix visual displays sales for MTD, QTD or YTD. The last selection of date range overrides previous one (so if the user firstly selected something on calendar and then used MTD, MTD is displayed finally). How can I do that? I would prefer to do that with DAX.
Thank you for your reply! Could you please give more details? I would prefer to do that in DAX. As far as I remember, bookmarkss give an opportunity to switch between different "states" of the pages but this is not what I really need. It is also unclear for me how can I switch between calendar and date slicer with bookmarks since there is no special button to switch between them in my dashboard.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.