Power BI Treemap Slicer

#PowerBI Tip: Use the Treemap, Column or Funnel Chart as a Colorful Slicer

Power BI Desktop has been out for GA for over a week now and some of the pro’s out there have come up with some pretty cool tricks. For instance:

But if you’re looking for a way to spice up you report filtering with a little color, try using the Treemap, Column or Funnel chart as a Slicer for those fields that only contain a few unique values. At this point with Power BI, you don’t have any customization options for the Slicer visualization (although I’m sure that is coming down the pipe in a future release). This option won’t work terribly well if the field you would like to use as a slicer has more than a dozen or so unique members, but you can experiment with it and see what you can come up with. Here’s my custom slicers in action.

column chart as slicer

tree map slice in action

Power BI Funnel slicer in action

To multi-select tiles in the custom slicer, just hold Cntrl as you click.

This little trick relies on the natural cross filtering between data regions in the Power BI dashboards. First I created a measure that calculates the distinct count of the field that I wish to use as my slicer. In this case the field is Genre.

Power BI Distinct Count DAX calculation

Then I added a Treemap/Funnel chart to the report using the field Genre as the Group value and the measure Distinct Count Genre as the Values.

image

Then just resize the visualization so that the squares are about evenly sized. There’s a few ways you can arrange it, but just play around with it and see what you can come up with.

Power BI Dashboard with Treemap Slicer

Power BI Dashboard with Treemap Slicer

image

Funnel slicer

If you are wondering how I made the column chart slicer, here’s a gif image that shows the steps I used. Enjoy!

Power BI column chart as slicer making of

Feedback?

What do you think? Leave me a comment below and let me know. Or if you’ve got a neat Power BI trick you’d like to share, let me know, as well. I love to hear new ideas! Thanks for reading!

17 thoughts on “#PowerBI Tip: Use the Treemap, Column or Funnel Chart as a Colorful Slicer”

    1. Hey, Dave. I don’t think you can turn the Funnel horizontally, but for the first slicer I used a column chart. Then I hid the Y axis and turned off the background and data labels. This .gif image shows how I made it: //sqldusty.com/wp-content/uploads/2015/08/column-chart-as-slicer-making-of.gif

  1. Hey Dustin, some neat tips. I especially like the funnel chart as a slicer, but how do you get rid of the top and bottom percentage indicators? Is this a new thing? Thanks Tony

  2. hi Dustin – how do you get the year slicer to not “pop up” and display what year it is and the count of that year. For example, when i click on 2015, a small black color window pops up showing 2015 and the count of rows for 2015.

  3. Hi Dustin, With the funnel chart how can I resize the squares while keeping the captions without being truncated as you did? Thanks.

    1. The funnel chart is kind of finicky. You can try just resizing the funnel chart or possibly moving the labels to the right side to see if that helps.

Leave a Reply