Forum Discussion
Slicer issue, would like to use AND rather than OR when selecting.
Hello, I am building a skill matrix at work. I have several slicers on the report for people to select Skill level, category, sub category, and location. Below I have a table that, as you select opt...
v-yulgu-msft
Microsoft Employee
Microsoft EmployeeHi DrDuran ,
I have to two issues, the first is that the slicer tends to use OR rather than AND, so if I select two skill from the slicer, I want to select a person that has both skills rather than a list of people who have those skills individually.
As I know, applying filters from different slicers actually use AND logic. That is to say, the visual shows data which matches all slicer selections.
The second it that before any selections have been made, all the information is on display. I'd like the table to appear empty until somebody starts to make selections.
You can use measure with IF statement to achieve this requirement. For example, Measure=IF(ISFILTERED(Table[ColumnName]),<expression>,BLANK())
For more advice, please post sample data and desired output. How to Get Your Question Answered Quickly
Best regards,
Yuliana Gu