cancel
Showing results for 
Search instead for 
Did you mean: 
RicoZhou

Power BI Custom Visual – Chiclet Slicer

Introduction:

Slicer is one of the most common and important controls for Power BI report design, which is quite helpful for many dynamics interaction. Although its operation procedure is very simple, the traditional slicer still can achieve the expected effects.

However, traditional slicer has limited customization settings, so when users want to design personalized effects, such as making the slicer have a mouse hover effect Which will be difficult for the traditional slicer. Therefore, I would like to introduce another slicer in Power BI: Chiclet Slicer to realize this requirement.

 

Operation procedure

Prepare a set of data then load this custom visual object in AppSource.

RicoZhou_0-1663925074670.png

 

Drag [Country] into the Category field to get this different slicer.

RicoZhou_1-1663925092658.png

 

You can also customize the order in which they are listed. Whether they are arranged horizontally or in a super compact matrix arrangement.

RicoZhou_2-1663925099995.png

 

In traditional slicer, if you want to check more than one item at the same time, you need to hold Ctrl to check them. But Chiclet Slicer supports batch ticking directly and cross highlighting on visual.

RicoZhou_3-1663925113762.png

 

Next, I'll introduce you to its coolest feature which can use images instead of text as filters.

Firstly, find the flag of different countries on the web and add the URLs to the table.

Set the type of the field [Logo] to "Image URL".

RicoZhou_4-1663925120645.png

 

Put this [Logo] field into the [image] box of Chiclet Slicer. Then a slicer with the flag image is generated.

RicoZhou_5-1663925130645.png

 

You can continue to embellish this slicer even without text, using only images for filtering.

The Images section under Format set the "Image Split" to 100 and the image will then take up 100% of the chiclet and crowd out the text all together.

RicoZhou_6-1663925143359.png

 

Summary

 

Are you already interested in it? Chiclet Slicer is an excellent control and you can try it out the next time you design a report.

 

Document reference: Visual Awesomeness Unlocked: The Chiclet Slicer | Microsoft Power BI Blog | Microsoft Power BI

 

Author: Xiaoting Yan

Reviewer: Kerry Wang & Ula Huang

Polls
What is your favorite Power BI feature release for November 2022?