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
Thanks for solutions. But it is not exactly what I need.
It wont change the values on x axis (showing year when I filter on months).
I`ve created a Dynamic Date table:
Is there any way I can use the "Dyanamic Date" column as a slicer, and connect the "Year" row to the
"(true/false) Last 3 Years" column in date table?
Example:
If I press "Year" It should return the last three years (they have value "True" in 'Date'[(true/false) Last 3 year]).