Forum Discussion

Ashok_Gopeani's avatar
Ashok_Gopeani
Icon for Helper I rankHelper I
2 years ago
Solved

Display slicer values based on selection in page filter

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 o...
Need Help
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    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

Ashok_Gopeani's avatar
Ashok_Gopeani
Icon for Helper I rankHelper I
2 years ago

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=xxxxxxxxxxxxx&filter=country/country eq 'Ind'

 

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's avatar
PijushRoy
Icon for Community Champion rankCommunity Champion
2 years ago

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