Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
darkmetrics
Helper I
Helper I

How to switch between calendar and date slicer with DAX?

Good afternoon!

I have a dashboard:

darkmetrics_0-1663656268130.png

It is based on daily data about sales in different channels. Visuals used in the dashboard:

  • Calendar by Tallan to select custom date range
  • Custom date slicer with 3 options: MTD, QTD, YTD. The slicer is based on SWITCH(), the SWITCH triggers custom measures which calculate sales month-to-date, quarter-to-date, year-to-date.
  • Matrix visual which uses Sales measure (some simple measure like SUM())

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.

2 REPLIES 2
darkmetrics
Helper I
Helper I

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.

amitchandak
Super User
Super User

@darkmetrics , I think you should use bookmarks

 

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks

 

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors