Microsoft Power BI

Chiclet Slicer_ A Custom Visual in Power BI

Power BI has some very useful and interactive visualizations that enhance the dashboard’s meaning, Chiclet Slicer being one of them.

These are slicer buttons that you can arrange either horizontally or vertically for efficient real estate use. Using the formatting tools, you can specify the number of rows and columns in the slicer. Not just that, you can also include images in your slicers, along with cross -filters.

So, in short, Chiclet Slicer forms a compact package of awesomeness!

Importing the visual from the Microsoft Power BI AppSource

It is among one of the many Custom visuals of Power BI that we need to be download separately before we can use it.

  1. Download the Chiclet Slicer from the following link: https://store.office.com/addinsinstallpage.aspx?rs=en-001&assetid=WA104380756
  1. Import it in your Power BI desktop by following the given steps
  2. Click on the three dots (highlighted)
  3. Click on “Import a visual from a file.”
  4. Click on Import
  5. Once imported, it will reflect as highlighted:
Contact us for interactive dashboards and quick database solutions.

Using Chiclet Slicer without Images

Now that our Chiclet Slicer is imported let’s see how to use it in our dashboard.

  1. Click on the Chiclet Filter
  2. Select the Dimension that you want to use in the filter
  3. Your filter is ready; you can change the formatting from the Format section.

But, to make it visually more appealing, let’s use images. (In the given example, I have used Country as the slicer, so I am using the flag of the respective countries)

Using Images from the Internet

  1. Create a separate table for Image URLs
  2. Once the URLs for the individual images are posted in the respective columns of the table, draw a relationship between the Data table and the URL table
  3. Follow the steps for creating a Chiclet Slicer graph using the new table

 

Images from the Local Drive

Since Power BI desktop works with online images, using images from the internet is easier than using images from the local drive. But, if you want to use local images in Chiclet Slicer or any other Power BI visual, here are simple steps for you:

  1. Go to edit queries
  2. Create a blank query
  3. Go to Advanced Editor of the blank query and use the following M-Script

let

BinaryToPbiImage = (BinaryContent as binary) as text =>

let

Base64 = “data:image/jpeg;base64, ” & Binary.ToText(BinaryContent,BinaryEncoding.Base64)

in

Base64

in

BinaryToPbiImage

  1. Click on done
  2. Click on New Source
  3. Select Folder and Connect
  4. Browse the folder where you have stored the Images
  5. Click OK to get all the stored images imported
  6. Now, Invoke the query to convert local images to Base64, by clicking on Add Column
  7. Then select Invoke Custom Function
  8. Name the New Column that you want to create for the Binary Images
  9. Select the Function Query name that you want to Invoke
  10. From the Dropdown Select the Column on which the Function will be applied, i.e., the first Column named as Content
  11. Click OK
  12. Make sure that you name your images correctly, and they can be used to draw a relationship with your existing tables.
  13. The Name Column can draw a relationship with your existing tables, but you need to remove the extensions. To do so, right-click on the Column, select Split by Delimiter. Check if period (. ) is selected as the delimiter. Click OK. Now you have the Unique names column ready.
  14. Close and apply
  15. Go to Relationships and check if the relationship between this new Column has been established with your data table’s existing column. If not, create the connection.
  16. Once that’s done, you are ready to use your local drive images in your dashboard and build a Chiclet Slicer.

Contact us for any queries.