Multiple items in slicer

[jimrosser]

So I have a slicer that is multi-select and has 3 items.  What I'd like to do is have an if statement that doesn't care if 1 and 3 are selected I only want to know that the 2 is selected and then perform an if statement.  

[jimrosser]

I'm pretty new to power bi so i'm not sure how to upload the pbix file. 

it's pretty basic dropdown list it has 3 check boxes.  The boxes are First, Seconds and Thirds quality.  The way it's set up now it displays all 3 quantities stacked.  I'd like to write an if statement to say that if Seconds is not selected then don't display them in the chart.  

[Anonymous · Accepted solution]

Hi @jimrosser ,

You can paste some raw data and screenshots in your post directly and describe the expected result base on your data. You can refer the following links to share the required info:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards

[Anonymous]

Hi @jimrosser ,

Could you please provide some  raw data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples? For example, when item 2 be selected, which operation will be executed?

• When only item 2 be selected
• When the item 1 or 3 be selected
• When (the item 1 or item 3) and item 2 be selected

It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards