Forum Discussion
DAX Dynamic Filter
Hello All, I have code used for dynamic filter. When the user choose a Year from the Year slicer it will display the chosen years in the visual. But I am trying to add a filter to this code (I do...
pfarahani Is _JBSIS Probate Dates Year Month a DimDate table containing dates beyond those that actually have data?
You could simply add a filter to the page or even filters on all pages sections or to a specific visual (depending on what you want), that says Display Year = 1
And that will ensure only valid dates are selectable.
Hi Allison,
I got a little closer, I created a variable which I tested. I just need to know where to apply the variable. To say, WHERE [Year] <= _MaxYear