Forum Discussion

ack2mani's avatar
ack2mani
Frequent Visitor
8 years ago

Multiple Slicers on same query

Hi All,   I am new in Power BI and stcuked in a situation where I have two slicers 1. Head Office 2. Branch Office in a report page. I have one query that contains full adress of both Head Office a...
Thejeswar's avatar
Thejeswar
Super User
8 years ago

ack2mani,

Ya I get that your table has both Head Office and Branch Office Address as separate entities.

 

If the Table and Slicers are going to be from the same Dataset the Slicer 2 will become blank when ever you make a selection to Slicer 1 as your entire dataset will get filtered.

 

If showing data in the slicer 2 even when something is selected in slicer is your need, that's not a big deal. But even after soing this you will have to manually deselect the Slicer 1

 

Instead have you Head Office ID and Branch office ID in 2 different columns and Addresses can continue to be present in the same column.

 

Have your head office ID Column in 1 slicer and Branch Office ID in another Slicer and edit interaction such that they don't filter each other. Edit Interaction is availabe in the format section of the slicer

 

In this case, For all the Branch Office IDs the Head Office ID will be Blank. So when ever you want to filter on Branch Office ID, select Blank in Slicer 1 which is Head Office ID and select the Sllicer 2.

 

This way it will work fine.

 

Regards,

Thejeswar

ack2mani's avatar
ack2mani
Frequent Visitor
8 years ago

Hi Thejeswar

Thanks! for the quick response.

But my requirement is to show branch office address in the card even if Slicer 1 value is selected. So If slicer 2 is selected while slicer 1 is still active my branch office address should overright headoffice address in the card.