Illustration of a rocket launching into the sky with bright flames, set against a backdrop of clouds, symbolizing growth, innovation, or a successful project launch.

Stacked Clustered Bar Chart

Stacked Clustered Bar Chart is a combination of Stacked Bar Chart and Clustered Bar Chart.

This chart provides quick insights for comparing multiple categories. These bar charts are an excellent way to display the contributions of parts of a whole effortlessly, depicting data values more effectively and visually. For example, they can show how much each categorical variable contributed to revenue during a particular period. Stacked clustered charts allow you to comprehend data while visually comparing total values in an effective manner. You can even plot a stacked clustered chart from Excel to Power BI.

Purchase the visual from AppSource by completing the checkout process. Then, add licenses.

Checkout page for Power BI Visual Transact Test with plan options.

  1. To add or assign licenses to Stacked Clustered Chart: Go to admin.microsoft.com, choose Billing > License.
  2. Select a Visual you want to assign licenses.

    Screenshot of Microsoft 365 admin center showing the Licenses page under Billing. The page lists a Power BI (free) subscription option.

The minimum required version for Power BI desktop application to use Stacked Clustered Chart should be July 2022 version or above.

  1. Open Power BI Desktop application.
  2. Sign in with your licensed email id.

    A Power BI Desktop application showing a Sign In button highlighted in red at the top right. Various icons for data visualization tools and filters are visible.

  3. Click on import custom visuals.

    A Power BI interface with a blank report canvas, toolbar icons for data import, visualization options, and fields panel on the right for data selection.

  4. Click Import a visual from a file, locate the pbiviz file, then click OK.

    The image displays a Power BI interface by expanding a dropdown with highlighting Import a visual from a file option. Power BI interface with a pop-up message stating, Import custom visual, the visual was successfully imported into this report on a white background.

  5. After the import is complete, you will be able to see Clustered Stacked Bar Chart icon.

    Screenshot of a BI tool interface with a blank canvas, featuring a toolbar with options like Insert, Modeling, View, and Visualizations etc,.

  1. Creation of stacked cluster chart requires four fields – Category 1, Category 2, Legend and Measure.
  2. Category 1 as displayed below is used for creating Cluster.

    Stacked Clustered Bar chart in a data analysis software showing sales by customer segment: Home Office, Corporate, Small Business, and Consumer. Color-coded by region.

  3. Category 2 is used for creating side-by-side bars within a Cluster. The order of Category 2 variables are highlighted below.

    Stacked Clustered Bar chart in a data analysis software showing sales by customer segment: Home Office, Corporate, Small Business, and Consumer highlighting the first cluster.

  4. Legend is used for creating a Stack within a bar of Category 1.

    Stacked Clustered Bar chart in a data analysis software showing sales by customer segment: Home Office, Corporate, Small Business, and Consumer highlighting the legend used for the stack within a bar.

  5. Measure is used for plotting values on the Y-Axis.

    Stacked Clustered Bar chart in a data analysis software showing sales by customer segment: Home Office, Corporate, Small Business, and Consumer highlighting the Measure to plot on Y-axis.

Frequently Asked Questions
  1. Once i assign a license, how long does it take to be operational?

    Once you have successfully assigned licenses in the Microsoft 365 Admin Center, it should be available within an hour.

    • If you’re using the licensed visual in the Power BI Service, refresh the report by hitting F5.
    • If you’re using the licensed visual in the Power BI Desktop, close and reopen it.

    If the license is still unavailable after refreshing, please wait a moment and try again. It may take up to an hour.

  2. Who can assign licenses after the purchase is complete?

    If the tenant admin owns the licenses (Org licenses), then any of the license admins (Global Admin, License Admin or User Admin) can manage the licenses. However, if the subscription owner isn’t an admin, then only the purchaser can manage the subscription and licenses.

  3. Can we use a visual without having to upload it to organization visual?

    Yes. You can download a visual directly to your reports.

  4. How do we get upgrades of the visuals?

    The AppSource visuals are updated automatically when a new version is available.

  5. How do I know if someone in my company has already purchased this same visual?

    If you’re a company administrator, sign in to the Microsoft 365 admin center see all subscriptions and to whom they’re assigned.

    If you aren’t an administrator, speak to the administrator in your company.

  6. How do I get support?

    If you need help, please visit our contact us page or reach out to us at sales@defteam.com