Forum Discussion
Slicer Options
Anonymous
If I can interest you in using an alternative slicer visual, namely "Hierarchical Filter", then the behaviour seems to be what you were looking for.
The problem with the Core Slicer visual is that "Select All" has the same effect as clearing all selections (confirmed by examining the DAX queries for the table visual).
There could be other methods but this seems a convenient one 🙂
Regards
Anonymous
The only method I can suggest is to write a measure that detects whether a filter has been applied on the slicer field, and apply this measure a visual-level filter on the table.
PBIX example attached.
In my PBIX, I created this measure:
Name Filtered =
INT (
CALCULATE (
ISFILTERED ( Data[Name] ),
ALLSELECTED ()
)
)Then added it as a visual filter to the table (set equal to 1):
Hi OwenAuger ,
Thanks for your reply.
This is working good.But if i select all option now also that table is blank.
I need if i click select all the table shows all the records.
You're welcome 🙂
Sorry, I missed the "select all" requirement. That actually makes it trickier, as "Select all" is equivalent to clearing the slicer at the moment.I will take a look and get back to you.
Anonymous
If I can interest you in using an alternative slicer visual, namely "Hierarchical Filter", then the behaviour seems to be what you were looking for.
The problem with the Core Slicer visual is that "Select All" has the same effect as clearing all selections (confirmed by examining the DAX queries for the table visual).
There could be other methods but this seems a convenient one 🙂
Regards