Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Limiting a visual till current selection

I have a slicer which is coming from Calendar table it has dates from 01-01-2015 to 12-31-2060, i have limited sllicer to year 2020 & 2021 with  var loaddate = max('Brand Attributes'[insert_timesta...
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Anonymous 

 

Please get familiar first with how to properly work with dates and times in PBI: Standard time-related calculations – DAX Patterns

 

Then, you can make use of this hint: If a measure returns BLANK, it will not be shown in a visual. Also, you can filter a visual through the Filter Pane and make use of any measure you find useful.