Stacked bar chart as a slicer in Power BI
New look of slicer
After the trick of a treemap as a slicer: 👇👇
Here a new tip (from “How to Power BI channel”) about a stacked bar chart as a slicer:
We can create and design great slicers with a new colored look instead of using the normal slicer, this time we will use the "stacked bar char " visual
Example: a slicer of product sub categories
We need to:
✔add the list of sub categories in the visual axis
✔add a simple DAX measure (size=1 ) in the values
✔disable the X & Y axis and enable the data labels => by default it will show the value 1 for all the bars, but in order to display the current value of the sub category, we will use the #calculation_groups in #tabular_editor and create a "#calculation_item with Format String Expression = the current value of the sub categories
✔finally we just need to add this calculation item in the visual filter and adjust the bar colors
😍it results in a really nice slicer
