Forum Discussion
POWER BI slicer
Hi Vaish1 ,
My bad did not understand that you want to have the value to the blank missread your question.
In this case you cannot have it using a between slicer because the blank on a column won't be picked up (it's a non value date) if you always want to pickup the blanks I would then use the calendar table but in a disconnected way and use a similar measure to filter out the visuals:
Filter calculation = VAR temptable = FILTER( Table, ( Table[submissiondatum ] <= MAX(Calendar[Date]) && Table[submissiondatum ] >= MIN(Calendar[Date])) || Table[submissiondatum ] = blank) Return Countrows (temptable)
Super UserHi Vaish1 ,
Create a calendar table and relate it with this column then you can use the new table on your slicer to get the data filter on the visualizations.
Still not getting option for blank value
- MFelix
Hi Vaish1 ,
My bad did not understand that you want to have the value to the blank missread your question.
In this case you cannot have it using a between slicer because the blank on a column won't be picked up (it's a non value date) if you always want to pickup the blanks I would then use the calendar table but in a disconnected way and use a similar measure to filter out the visuals:
Filter calculation = VAR temptable = FILTER( Table, ( Table[submissiondatum ] <= MAX(Calendar[Date]) && Table[submissiondatum ] >= MIN(Calendar[Date])) || Table[submissiondatum ] = blank) Return Countrows (temptable)