Chic look in Power BI with Chiclet Slicer

Chic look in Power BI with Chiclet Slicer

Enhance your Power BI report with new slicing options. Using custom visuals in Power BI report creation gives you a perfect opportunity to extend built-in visual capabilities above and beyond.

Using custom visuals in Power BI report creation gives you a perfect opportunity to extend built-in visual capabilities above and beyond. There are literally hundreds of custom visuals in Appstore and I advise you to check them when you want to enrich your reports with non-standard visuals.

That’s one of the main strengths of Power BI — you can literally choose between hundreds of visuals to tell your data story in an appealing way.

Chiclet Slicer

Recently, I came across a specific request to enable slicing customers based on their last names. They were sorted in alphabetical order, but the request was to see only customers whose last name starts with, let’s say, R.

Step 1 was to import Chiclet Slicer visual from the marketplace. Click on three dots under the Visualizations pane and choose Import from AppSource.

Image for post

Now, you are ready to go and use Chiclet Slicer in your report. The next step is to extract only the first letter from the customer’s last name. I will use Adventure Works 2017 database for demo purposes.

Since I want to see customer’s full name, I will first create a new column within DimCustomer table and concatenate customers’ last name and first name:

Full Name = DimCustomer[LastName] & " " & DimCustomer[FirstName]

power-bi towards-data-science data-visualization data-science data

Bootstrap 5 Complete Course with Examples

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Building a simple Applications with Vue 3

Deno Crash Course: Explore Deno and Create a full REST API with Deno

How to Build a Real-time Chat App with Deno and WebSockets

Convert HTML to Markdown Online

HTML entity encoder decoder Online

Tableau vs Power BI: Comparing the Data Visualization Tools

In analytics, Tableau is the leading visualisation tool. Its rich analytical features and attention to data details are the reason behind its popularity. Power BI, on the other hand, is preferred by professionals who are more comfortable with...

Power Query tips for every Power BI Developer

Use these simple yet powerful techniques to speed-up your Power BI development. If someone asks you to define the Power Query, what should you say?

Explore your JIRA Data with Power BI

JIRA Software provides bug tracking, issue tracking, and project management capabilities for teams and organizations. The JIRA content pack for Power BI helps you quickly import JIRA data so you can get an instant dashboard to analyze workloads...

Managing your Data with Microsoft’s Power BI

In a world where the sheer amount of data is often overwhelming, the ability to interrogate and organise data to make meaningful business decisions is more important than ever. Microsoft have created Power BI to enable every day users to use the...

Push Card visuals to a new level in Power BI

Push Card visuals to a new level in Power BI. Bring new life to traditional Power BI visuals and learn how to achieve expand/collapse functionality with a simple workaround