Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 ...
Need Help
  • Samarth_18's avatar
    Samarth_18
    3 years ago

    Anonymous , You need to apply measure as visual level filter. Please refer the attached PBIX.

Aburar_123's avatar
Aburar_123
Icon for Solution Supplier rankSolution Supplier
3 years ago

Hi Anonymous ,

 

Please write the measure like below and place it in the visual level filter of the slicer

 

uptoTodayFlag = if(MAX(Date_Dim[Date])<=TODAY(),1,0)