- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 and Branch Office in same column.My problem is when I select a Head Office it shows address correctly but when I select a Branch office my card still shows Head Office address since previous selection is active.
My ask is based on the selection in slicers 1, 2 my card should show corresponding address.Both slicers are two different data sets and joined with my query on OfficeID column
Any help is appreciated.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @ack2mani,
Can you pleasse share some sample data and expected result.
Regards,
MFelix
Regards
Miguel Félix
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Check out my blog: Power BI em Português- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi MFelix
below is the sample
Slicer 1(Regional Head Office Id) |
1 |
2 |
3 |
Slicer 2 (Branch Offices id) |
123 |
567 |
345 |
Office Address | |
ID | Address |
1 | 380 Summit Ave |
2 | 2925 Chicago Ave |
123 | 1445 Ross Ave Suite 1400 |
567 | 1345 Philomena St |
345 | 8110 Gatehouse Rd |
the slicer data sets are joined with Office address query with ID's. So my requirement is When I select 1 from slicer 1 then address should be "380 Summit Ave " and when I select 123 from slicer 2 while slicer 1 value is still selected the adress should be "1445 Ross Ave Suite 1400"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @ack2mani,
Please clarify something
Is your data like 1 Head Office will have some Branch Offices under them?
- If so the structure in which your table is might not be the best way to have the data to make it work the way you want.
or Is there something else your head office and branch office are related? or are they completelt not related to one another?
Regards,
Thejeswar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Thejeswar
My table consists of address of both Head Office and Branch office addresses as seperate entries. So my Concern is while slicer 1 is selected and active my slicer 2 becomes idle because table is alredy filtered based on slicer 1 value. Please suggest any better approach to acheive my goal.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @ack2mani,
Just to understand when you have one selection on slicer 2 it should show that slicer address if you don't have any slicer it should show slicer 1 adress right?
Regards,
MFelix
Regards
Miguel Félix
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Check out my blog: Power BI em Português- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @MFelix I am using Card to display office addresses and above is the sample and expected output
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - January 2025
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
Subject | Author | Posted | |
---|---|---|---|
08-29-2024 03:51 AM | |||
06-01-2024 06:09 AM | |||
08-29-2024 12:56 AM | |||
08-15-2024 11:33 AM | |||
08-21-2024 08:02 AM |
User | Count |
---|---|
101 | |
72 | |
47 | |
39 | |
33 |
User | Count |
---|---|
157 | |
101 | |
60 | |
43 | |
40 |