topic Re: Can we merge two slicers into one slicer? in DAX Commands and Tips

Can we merge two slicers into one slicer?

MandyL — Mon, 15 Jan 2024 10:46:16 GMT

Hi Team,

Can we merge two slicers into one slicer? I’m trying to do is create one slicer, when user pick “Yes” value then it will apply all data; when user pick “No” value then it will apply Column B equals “No”. Thanks!

Column A: Only “Yes” value
Column B: “Yes” and “No” value

Column A	Column B
Yes	No
Yes	Yes
Yes	No

Slicer:
Yes => All Data
No => ColumnB=”No”

Re: Can we merge two slicers into one slicer?

123abc — Mon, 15 Jan 2024 13:23:56 GMT

In Power BI, you can create a calculated column that combines the information from both columns A and B into a new column, and then use this new column for your slicer. Here's a step-by-step guide:

Create a Calculated Column:
- Go to the "Model" view.
- Find your table in the Fields pane.
- Right-click on the table, and select "New column."
Write the DAX Formula:
- Use a DAX formula to create a new column that combines the information from columns A and B. For example, if your table is named "YourTable," and the columns are named "ColumnA" and "ColumnB," you can use the following formula:

CombinedColumn = IF(YourTable[ColumnA] = "Yes" || YourTable[ColumnB] = "Yes", "Yes", "No")

- This formula checks if either ColumnA or ColumnB has a "Yes" value and assigns "Yes" to the CombinedColumn, otherwise, it assigns "No."
Create a Slicer:
- Go back to the "Report" view.
- Select the "CombinedColumn" you just created.
- Click on the "Slicer" icon in the Visualizations pane to create a slicer visual.
Configure the Slicer:
- In the slicer visual, you can now use "Yes" and "No" to filter your data based on the logic you specified.

By using this approach, you have essentially merged the information from columns A and B into a new column that you can use for filtering using a slicer. Remember to adjust the table and column names according to your actual data model.

Re: Can we merge two slicers into one slicer?

Anonymous — Tue, 16 Jan 2024 03:19:09 GMT

Hi MandyL ,

Based on the information you provided, you may consider adding two buttons and two bookmarks, one bookmark shows all the data and the other bookmark shows "No" in Column B.

Ctrl+click the button to follow link:

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

^{Best Regards,}

^{Yifan Wang}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}