Forum Discussion
Removing months from slicer with no data
Hi All, I have a table that I have uploaded to powerBI with dates ranging from begininning of July till end of November. I had put a slicer on the dashboard in dropdown view. However months from ...
o_belov
Advocate II
Advocate IIHow did you get the names of the months from the dates?
Do you use an auxiliary calendar table of type dimDate in the model?
If you use month from auxiliary calendar table, then create measure for slicer, like
IsDateInScope =
IF(SELECTEDVALUE(financials[Date]) IN VALUES(dimDate[Date]), 1, 0)
add it in filter pane for slicer and choose is 1
add it in filter pane for slicer and choose is 1