topic Re: Multiple items in slicer in Developer

Multiple items in slicer

jimrosser — Thu, 05 Jan 2023 20:50:41 GMT

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.

Re: Multiple items in slicer

Anonymous — Fri, 06 Jan 2023 07:42:15 GMT

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

Re: Multiple items in slicer

jimrosser — Fri, 06 Jan 2023 13:12:07 GMT

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.

Re: Multiple items in slicer

Anonymous — Mon, 09 Jan 2023 07:21:37 GMT

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