Forum Discussion
Two slicers for one column
Power ParticipantIn the example you've shown, you can easily select two products with the help of one multi-selection visual...
Hi AliceW,
thanks for your support.
This is an easy possibility and it works.
However, it would be the objective to have two seperated slicers. One seperate slicer only for products of category A and one for products of category B, both slicing a singe column. Is this possible?
- AliceW
Info: is having two and only two products in the visual the expected result? And is the list of products reasonably short? If yes to both, you could build two one column tables with the product names, then build two measures using SWITCH in the main table, then use those measures in the visual.
Hi..
Could you please elaborate on "then build two measures using SWITCH in the main table, then use those measures in the visual"
I am also facing the same need for comparing our and competitor products.
Thanks
- AliceW
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.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.
