Re: How to create 2 slicers which should not show ...

JaipalAnu · ‎08-25-2023

How to ensure that when a value is selected in the first slicer, the second slicer will only show the remaining values that are not selected in the first slicer in power bi?

I have a report name called Financial Comparison, so here i have cost plan column, i wanted to use 2 slicers with the same column name (cost column) and the values are A,B,C,D in both. So when i filter 'A' in first slicer then the second slicer should show B,C,D not A because i selcted A in first slicer. Also, both the slicers should work for the fitering the entire report. Attached image. Please need a help.
@parry2k @Microsoft @NandhaKumar @pro @npowerbi

parry2k · ‎08-25-2023

@JaipalAnu share the sample pbix file, remove any sensitive information before sharing, and I will put the solution together.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

JaipalAnu · ‎08-28-2023

Hi @parry2k ,

My Slicers are working well on both sides (Slicer 1 and slicer 2) and it is filtering both the values in the chart, my problem here is as attached in the image the Actual has to show permanant in the chart and the chart has to filter the data based on the both slicers selection.

Result : If slicer one selected 2023 1+11 and slicer 2 selected 2023 2+10
then the chart should show Actuals , 2023 1+11 data and 2023 2+10 data. Attached image.

JaipalAnu · ‎08-25-2023

I tried that before, but when i filter multiple values in the first slicer then It is showing all the values in the second slicer and I'm not able to filter the report using both the slicers at a time. Attached both the images.