During the Day 1 Keynote of Data Insights Summit (#MSDataSummit), five (plus 1) new Power BI visuals have been introduced. The one that first got my attention was the Attribute Slicer visual. Exactly the functionality a customer requested in the last days – “Isn’t there an autocomplete filter in Power BI available?!”. At that meeting I had to answer with “no” but the Attribute Slicer looks perfect for this kind of filter scenario. But let’s see..
I’ve prepared a small test table containing city and country names….
… and imported the data into Power BI
Download and Import Custom Visual
The Attribute Slicer visual is a custom visual published by Microsoft and available in the visual gallery at powerbi.com (http://visuals.powerbi.com). If you haven’t visited that site so far – take a look at all those great visualizations!
The Attribute Slicer is currently in experimental state (as of 2016-03-23) but anyhow – I would like to see it in action! Therefore we need to download the pbiviz file and import it into Power BI Desktop.
Import the custom visual file into Power BI Desktop:
After the successful import you get a) the following message box..
… and b) your visualization toolbox is enhanced by the newly imported visual.
Usage of Attribute Slicer
For my upcoming tests I add a new instance of the Attribute Slicer visual to my report canvas and drag&drop the column CityName
The visualization itself is divided into two parts: the input-textbox and the list of entries (based on your entered search term).
Let’s try a simple one: I want to filter for entries starting with ‘B’
BUT: when I enter a lowercase b – the results list is empty .
Based on the current available version I am not able to change the search functionality to be case insensitive – may a hint for @MSPowerBI to extend the functionality to either search case insensitive or add an option for the user to decide.
Back to the search results for cities starting with ‘B’ –> if you select an entry, this entry is added as a selected entry and the filter looks like this:
You can add additional filter terms to the selected list (those entries are combined and the other visuals in your Power BI report are filtered accordingly).
To conclude, the first version of the Attribute Slicer visuals works already fine. There is space for some improvements like a case sensitive / case insensitive option, the UI looks a little bit blurry, and some color choice could be maybe improved. But for the first (experimental) version – a very good start!