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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
JenniferWallace
Frequent Visitor

Stacked and clustered chart combo

i have these 4 measures
Base Share Period, Increment share Period,
Increment Share Comparison Period and Base  Share Comparison Period 
 
i want to show Periods(base and incr) on one stack and CP(base and incr) on one stack side by side x-axis should be Customer. Can we achieve this using dax and Power BI built in visual.
 
1 REPLY 1
ValtteriN
Super User
Super User

Hi,

This isn't possible with core visuals. So you need to use a custom visual or do something like this:

So in my example the four measures used are [base], [incr], [comp1] and [comp2]

I created two new measures based on the two categories we have =

Base + incr = [Base]+[Incr]

 

Comp1 + comp2 = [Comp1]+[Comp2]



Now I used Line and clustered column chart:

ValtteriN_0-1701268339073.png

 

In the line width select 0 

ValtteriN_1-1701268379546.png

 

Enable markers:

ValtteriN_2-1701268409721.png

Now The Markers act as break points: 

ValtteriN_3-1701268468542.png

M1 = base 
M2 = incr 
M3 = comp1 
M4 = comp2


This isn't ideal but using this or someworkaround with small multiples are your best bets.

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.