Stacked Clustered Bar Chart is combination of Stacked Bar Chart and Clustered Bar Chart
This chart provides quick insight when comparing multiple categories
- Category 1 : This field is used for creating cluster
- Legend : This field is used for creating stack within each bar
- Category 2 : This is used for splitting cluster field
- Measure : Numeric variables plotted on Y Axis
Note : Chart will be blank if number of categorical variables are less than 3
Load the data into Power BI or connect to any database engine.
Import Stacked Clustered Bar Chart developed by DEFTeam.
There are two ways to import the custom visual:
Using pbiviz file.
Click on Import custom visual
Then Click on Import a Visual from file
Select the location of the pbiviz file and then Click on OK to import the custom visual
After successful importing the file you will be able to see Clustered Stacked Bar Chart icon
If your Power BI Admin has imported the visual, you can import from Organization marketplace. We recommend this method for importing visual for large number of users.
STEP 3: Creating Stacked Bar Chart
Add Category 1, Legend, Categorys, Measure to the chart
Category 1 is used for creating the Cluster
Category 2 is used for creating side by side bars within cluster
Order of Category 2 variables are highlighted above
Legend is used for creating Stack within bar of Category 1
Measure is used for plotting values on the Y Axis
Paid features of stacked clustered bar chart are enabled in Properties tab of visual.
Free Version supports up to 30 rows
Paid version will support up to 10000 rows
– Custom Bar Color
– Cross filter
– Bar Gaps
Also when “Paid feature” is disabled in properties tab ‘Click to turn on drill down’ will not work.
When license is expired paid visual will not be displayed but user can switch to free visual by disabling Paid Feature option.
When “Paid Feature” is on and license is expired visual will not be displayed.
When “Paid Feature” is off and license is expired free visual with limit of 30 rows will be displayed
Follow the below steps to add the license key
Open Power BI Application
Create a report after adding the dataset
Click on Stacked Clustered Bar Visual
Open Formatting tab
Enable Paid Feature
Click on Activate License
Copy and Paste the license key provided by DEFTeam sales team.
Note: When License is added please clear all the fields of custom visual (Stacked Clustered Bar Chart) and then add the fields again.
DEFTeam is a Microsoft gold certified Data Analytics partner and offers Services on developing PowerBI Solutions.