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

PijushRoy's avatar
PijushRoy
Icon for Community Champion rankCommunity Champion
2 years ago

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's avatar
Ashok_Gopeani
Icon for Helper I rankHelper I
2 years ago
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