Question

Is it possible to design a pyramid-shaped button slicer layout for visual filtering in Power BI?

I want to design a pyramid-shaped button slicer in Power BI for visual filtering, and I’m seeking advice on whether this layout is possible and how to implement it effectively.

Answer 1

While Power BI doesn’t natively support a pyramid-shaped slicer, you can implement a custom design using buttons and bookmark navigation. Here’s how you can create a pyramid-shaped button slicer for visual filtering:

1. Create a Pyramid Layout:

   • Use shapes or images to create a pyramid structure on your report page.

   • You can arrange buttons or slicer visuals in a pyramid shape by manually positioning them.

2. Use Bookmarks:

   • Create bookmarks to represent different filter views based on the slicer button selection.

   • Each button will correspond to a bookmark, allowing the user to filter data as they select each one.

3. Set up Action on Buttons:

   • Assign an action to each button, linking it to the appropriate bookmark for filtering.

   • Ensure the action is set to “Bookmark” and choose the relevant bookmark to switch between filter states.

4. Customize Button Appearance:

   • Adjust the button style (size, shape, background color) to create a visually appealing pyramid layout.

   • Use icons or text on the buttons to represent filter options.