Forum Discussion
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 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.
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-step2nd
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
13 Replies
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- 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
Hi Ashok_Gopeani
In place of a page filter, please use Deal_Name as a report Slicer.
Please check and let me knowwith this Deal_Name report slicer and page filter, behavior is same. ideally it should work but its not working for my scenario
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 LIKEbutton if this comment helps you.
