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
-
Step 1
Load the data into Power BI or connect to any database engine.
-
Step 2
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
-
Using Organization
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.
