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 options, it narrows down the individual.
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.
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.
I appreciate any help or advice. Thank you.
Regards, Paul.
2 Replies
v-yulgu-msftMicrosoft Employee
Hi 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
- Ashish_Mathur
Super User
Hi,
I am not sure of how much i can help but i would like to try. Share some data and show the expected result.
