Forum Discussion
Filter out data by dates till yesterday
Hello Powerbi Developers, I am having one requirement. I am having date column in which data is for whole year, but we want to show dynamically with help of Today() -1 function. eg today is ...
Anonymous , You need to apply measure as visual level filter. Please refer the attached PBIX.
Samarth_18
Community Champion
Community ChampionAnonymous , You need to apply measure as visual level filter. Please refer the attached PBIX.
Ah, that works. Thank you!
One final thing, if I may.... I have two tables that each have their own date (in the same format). Is there a way to make one slicer do a filter on dates and pull back the necessary statistics?
I can share my pbix file if that makes it easier
- Samarth_18
Anonymous You could create a date table and join your tables to it. Then use date table on slicer.