Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
rsbin
Super User
Super User

Deneb: Template for clustered stacked column chart

Good Day All,

Just starting to dip my toes into Deneb. 

Reaching out to see if anyone can point me to a template for a combo Clustered Stacked Column chart to help me get started.

 

Much thanks and kind regards,

4 REPLIES 4
rsbin
Super User
Super User

@mahoneypa ,

Hoping I found the right Pat.  Been studying your video on creating a Stacked Clustered Column Chart using Deneb.

rsbin_0-1685129107545.png

This is created using a dummy table.  My actual model currently has two Measures, one for each of the two Categories (Historical and Today).

Was hoping to get some guidance as to whether using 2 Measures can be done, or would I need to combine them into 1 Measure?

"y": {
        "field": "Inspections_SUM",
        "type": "quantitative",
        "stack": "zero"

Much kudos for the video and any further guidance would be much appreciated!

Kindest Regards,

I have a solution for this 🙂 Does it solve your issue?

https://www.villezekeviking.com/how-to-combine-a-clustered-and-stacked-chart-in-power-bi/

 

Good luck!

Greg_Deckler
Super User
Super User

@rsbin So like this? Stacked Bar Chart | Vega-Lite


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler ,

Thanks for the quick response, but not exactly.  I found the stacked, but haven't been able to find a combination clustered - stacked chart.  Something like this:

rsbin_0-1685119003763.png

Have tried using the hierarchy available with the native stacked column chart, but can't get the look and feel right with my dataset.  So thinking Deneb would enable me to perform the customization that I need.

Any other suggestions?

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.