Display slicer values based on selection in page filter

[Ashok_Gopeani]

Hi All,

i am trying to build dashboard with with heirarcy slicer with three columns DealName--> PoolName ->Scenario and i have page filter with Deal Name. i want to display the values in slicer only when if i select deal name in page filter. at present all values are displaying if didn't select any value in filter.

page filter

slicer values

could you pleae verify and let me know any solution to this.

[PijushRoy]

Hi @Ashok_Gopeani 

In place of a page filter, please use Deal_Name as a report Slicer.
Please check and let me know

[Ashok_Gopeani]

with this Deal_Name report slicer and page filter, behavior is same. ideally it should work but its not working for my scenario

[PijushRoy]

Hi @Ashok_Gopeani 

Can you look into the pbix file (for same type solution)
https://drive.google.com/file/d/1f-3D3x_mx0TWFzUXwyw5TDk0bw_qAfQR/view?usp=drive_link

If your requirement is solved, please make sure to MARK AS SOLUTION and help other users find the solution quickly. Please hit the LIKE  

 button if this comment helps you.

[Ashok_Gopeani]

thank you for your response and sending detailed implementation but my requirement is little bit different with your pbix file. here i am attaching my pbix file like. please verify suggest 

https://drive.google.com/drive/u/1/folders/1E3z9e6HRRknQlcdIfmtsb-dJb72q5kQ6

[PijushRoy]

Please give access to all with this link

[Ashok_Gopeani]

please try with below link

https://drive.google.com/drive/folders/1E3z9e6HRRknQlcdIfmtsb-dJb72q5kQ6?usp=drive_link

thank you

[PijushRoy]

Not working
Please follow 

[Ashok_Gopeani]

please try with below links

https://drive.google.com/drive/folders/1E3z9e6HRRknQlcdIfmtsb-dJb72q5kQ6?usp=sharing

https://drive.google.com/drive/folders/1E3z9e6HRRknQlcdIfmtsb-dJb72q5kQ6?usp=drive_link

[PijushRoy]

Hi @Ashok_Gopeani 

There are no relationships between table, please check I have updated
SetCountry measure I move to Country_Dup (as per relationship), please check

Find the updated pbix link
https://drive.google.com/file/d/13NGPbba4CU1qbbPguVJcGwzbSIJrsWYm/view?usp=sharing

If your requirement is solved, please make sure to MARK AS SOLUTION  and help other users find the solution quickly. Please hit the LIKE  button if this comment helps you.

Thanks
Pijush
Linkedin

[Ashok_Gopeani]

Hi @PijushRoy 

sorry for delay in reply and actually my requirement is we will initiate the web url from different system there we have button and this url has configured. Once user click on the button below sample url will hit and power bi dash board will load

https://app.powerbi.com/reportEmbed?reportId=ff577b5d-16b3-43e5-8e8a-d379583fb1a4&autoAuth=true&ctid...

in this particular requirement we should use page filters only as per my knowledge. now by default dash board will load with country name Ind then user may other country if required to see that country in slicer.

Now my requirement at this stage is, the heirarcy slicer should show the countries those i selected in the page filter and it should not display any country if i didn't select any in the page filter.

i have removed country_dup data source and i have only one data source, could you please help me with solution. i have attached file in below link. i hope i have explain my requiment correctly.

https://drive.google.com/drive/folders/1E3z9e6HRRknQlcdIfmtsb-dJb72q5kQ6?usp=drive_link

Regards,

AshokG

[PijushRoy · Accepted solution]

Hi @Ashok_Gopeani 

If you are using Country at page level filter, why you are using same in visual slicer.
If you use Country in visual slicer, it will not work.

Which solution I am suggesting now, will be more user-friendly.
Look into this step-by-step

2nd

3rd

Hope it will work for you. Let me know if that works for you
Don't forget to hit Like button.

https://drive.google.com/file/d/13NGPbba4CU1qbbPguVJcGwzbSIJrsWYm/view?usp=drive_link

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

[PijushRoy]

Hi @Ashok_Gopeani 

Please create a Measure,

Deal Name Filter True = 
IF(
ISFILTERED('TableName'[Deal_Name]),
1,0)

Now in slicer, use the filter in Visual Level filter and set as 1

Let me know if this works

If your requirement is solved, please make sure to MARK AS SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

[Ashok_Gopeani]

i have created measure SelectedDeal = IF(ISFILTERED(table_name[DEAL_NAME]),1,0) and i have reffered this measure at visual level filter. some how its not working. Please refer the screen shot for the same