Forum Discussion
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...
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"
