Stacked and clustered chart combo

[Pranali_R]

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.

@Dangar332 

[ValtteriN]

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:

In the line width select 0 

Enable markers:

Now The Markers act as break points: 

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/