Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I need some help/idea/workaround to achieve the following -
I have one Slicer1 with two option to show sales data Eg. "Show By Product", "Show by Salesmen"
If Show by product is selected then I want Slicer2 (seperate Slicer) to list all available products to chose from and dropdown for Salesmen is of no use.
If Show by Salesmen is selected then I want Slicer3 (seperate Slicer) to list all available Salesmen names to chose from and in that case product slicer becomes useless.
Now I was thinking to user two slicers one for product and another for salesmen and stack them on top of each other and then depending on the Choice in Slicer1 controls its visibility so if By product is selected hide the salesmen dropdown and vice versa however since the visual filters do not work with slicer need some workaround.
Any help from experts ?
Thanks
Solved! Go to Solution.
Hi @shaileng,
I have made a workaround using slicers 2 shapes on top of slicer and bookmarks, see below the step by step:
Add your slicer to your template (I have create the first slicer big to place the images on top
Open the bookmark and selections panes and create two views:
Salesman: Slicer 1 with Salesman selected, visualization hide Products slicer
Products: Slicer 1 with Product selected, visualization hide Salesman slicer
Add two images square or other things and link it to the bookmarks you created and placed it on top of the slicer:
On the PBI desktop you need the CTRL + Click on the images to make it work on PBI web it will work with click:
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsVote for this Idea - https://ideas.powerbi.com/ideas/idea/?ideaid=1bda1a4b-8438-ec11-b76a-281878bd589b
Hi @shaileng,
I have made a workaround using slicers 2 shapes on top of slicer and bookmarks, see below the step by step:
Add your slicer to your template (I have create the first slicer big to place the images on top
Open the bookmark and selections panes and create two views:
Salesman: Slicer 1 with Salesman selected, visualization hide Products slicer
Products: Slicer 1 with Product selected, visualization hide Salesman slicer
Add two images square or other things and link it to the bookmarks you created and placed it on top of the slicer:
On the PBI desktop you need the CTRL + Click on the images to make it work on PBI web it will work with click:
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @shaileng,
From what I know, we can't control a slicer's visibility. Please share your data model with dummy data, and list the expected result, so that we can check if is practicable.
Best Regards,
Angelia
Hi @shaileng
With the new bookmark and visualization pane you can do this. Check this link and if you need any additonal help please tell me.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
127 | |
108 | |
100 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |