Two slicers for one column

Question

Hi guys,&nbsp;I am quite new to PowerBI. I would like to have two slicers with products of different categories, which filter one column of a connected table with all product information of both categories.&nbsp;Is there a possibility to do that with connected tables? I have already found some approaches with disconnected tables and measures, but this inhibits the connection to other visuals in the dashboard.&nbsp;My inital ideas for a solution:1) Slicers with an OR condition2) Only slice products of a specific category in the info table --&gt; Is there a function to limit a slicer only on flagged entries?&nbsp;Thank you in advance!

tnt · Answer

Hi..&nbsp;Could you please elaborate on "then build two measures using SWITCH in the main table, then use those measures in the visual"&nbsp;I am also facing the same need for comparing our and competitor products.&nbsp;Thanks

alicew · Answer

This is what I do to allow the users to switch the report visuals between currencies.1. I created a table (Home / Enter Data) with two values: EUR and USD. You can use as many as you want. Called it 'Currency'. No need to create any relationship with this table.2. In the table where you have your amounts, create this measure:Total =SWITCH(TRUE(),SELECTEDVALUE('Currency'[Currency])="EUR",sum(Opp[Total EUR]),SELECTEDVALUE('Currency'[Currency])="USD", sum(Opp[Total USD]),sum(Opp[Total EUR]))The last sum is just in case you use the measure without the switch...3. In the report, you add a Slicer with the 'Currency' column. In its Selection Controls, make sure you have 'Single Select' on.4. Build the visual with the new Total Measure.&nbsp;You can apply this logic to your competitor issue; have two one-column tables and two switch formulas and two measures you get in the visual.

alicew · Answer

Hi Pechher,May I ask why would you need TWO slicers based on the sames column?If you want the user to be able to select only one Category, you can make the visual into a one-selection.As for limiting the slicer to only some options, you can do that by creating a page or report level filter with that column, hide it, and within just select the options you want to be seen. The slicer will only display those.Hope this helps,Alice

anonymous · Answer

Hi AliceW,the user just has a tremendous advantage to have two slicers, in order to compare product counterparts of different categories in one visual. Referring to the screenshot, the selection could be Slicer 1: Product A &amp; Slicer 2: Product F:Applying a page level filter on dublicated slicers with "Product" from "Aggregated Table" does not allow a selection in both slicers, because of the connections.&nbsp;An OR condition could be a solution for the two slicers, right?&nbsp;Hope this explaines my problem better.

alicew · Answer

In the example you've shown, you can easily select two products with the help of one multi-selection visual...

Forum Discussion

Two slicers for one column

10 Replies

Related content

Slicer for filtering several columns

Parameter slicer with measure for multiple columns

sort slicer by another column

column headers as a slicer

Slicer