Forum Discussion
Multiple items in slicer
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.
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
3 Replies
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
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.
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
