Forum Discussion
Solved
Period slicer using calculated columns
I am pretty new at Power BI, but I can't wrap my head around this problem: In my date table I have these 4 columns: These columns returns true/false values if the date is in "the last 12 ...
You can use the built-in slicer for creating dynamic date ranges like "last # day" or "last # month" etc.
Follow these steps: make a slicer > Slicer settings > style: Relative Date
you can try to create a measure.
= if(selectedvalue(column)="Year" && max((true/false)Last 3 years)=true(), 1)
then add this measure to visual filter and set to 1.