Power BI Challenge 10- Supplier Insight

Hi @YusufGillani to make the slicer menu what I did was the following:

  1. Insert → Shapes → Rectangle to the page and size it to where you want the panel to be.
  2. Turn off the fill, make line fully transparent, and turn on the background (color that the panel color you want).
  3. Open the selection and bookmark panes, View → Bookmarks and View → Selection (the selection pane allows you to specify the z-order, or which objects are on top of others, on the page, as well as hiding and showing of objects.
  4. Add slicers and place them on the panel. If you are using existing slicers, you will need to order them higher than the panel in the selection pane so they are “on top” of the rectangle shape.
  5. I typically make them dropdown slicers, with search turned on, and no background, but you can format however you like.
  6. You can also add text boxes – you get the idea!
  7. Now I add two buttons, one to hide and the other to show the panel. I like to keep these in the same place off the panel, so I user can simply toggle the panel without moving the mouse. Insert → Buttons → Blank, then turn off icon, outline, and background. Turn on fill. I go get a menu icon from remixicons.com and click on “add image” (in the fill section). I also like to have default state a lower transparency than the hover state, and also add a background color on press state.
  8. Now all the pieces are created so we need to get it working. In the selection pane, hold down ctrl and click all the visuals that are part of the panel and one of the buttons, right-click and choose group. This group should be at the top of the selection list, and the other button should be directly under it.
  9. click on the group in the selection pane and add a bookmark. Click the “…” next to the bookmark and choose “Selected Visuals” so it now has the green check mark, and choose “Data” so it loses its check mark. This is super important! You can double click the bookmark to rename it, and rename it “Show panel”.
  10. Now click the little eye for the group to make it invisible on the page, then making sure that group is still the only visuals selected, make another bookmark. Same as before, “selected visuals” only and uncheck “data”. Rename this one “Hide panel”.
  11. On the button outside of the group, click that one and add it’s action to be the bookmark “show panel”, and you can specify the tooltip as well, which I usually name “show panel”.
  12. Ctrl-click the button to show the panel.
  13. On the button inside the group, click that one and add it’s action to be the bookmark “hide panel”, and you can specify the tooltip as well, which I usually name “hide panel”.
  14. Now you can ctrl-click that button to test it, which should cause the panel to hide.

That’s how it’s created :slight_smile: Making sure your “Data” is unselected is very important or the slicers will reset when the panel is triggered which defeats the whole purpose.

4 Likes