Re: Date Filter - Help

Anonymous · ‎03-09-2020

Hi All,

If the ’Start Date’ is 1/1/2017 for the dashboard, is there any way to stop the date filter from going back prior to that date?

For example, I want the dashboard to throw out an error when a date before 1/1/2017 is selected.

Greg_Deckler · ‎03-09-2020

Maybe create a measure and filter on that? Or just filter the slicer to dates on or after 3/9/2017? Not certain that will work.

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

amitchandak · ‎03-09-2020

You can use from date calendar and do not have date before that.

Also refer

https://community.powerbi.com/t5/Desktop/Limit-Calendar-table-to-latest-date-of-Fact-table-within-M/...

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