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.
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.
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]
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...
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?
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...
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. Bring new life to traditional Power BI visuals and learn how to achieve expand/collapse functionality with a simple workaround