Forum Discussion

Pranali_R's avatar
Pranali_R
Frequent Visitor
2 years ago

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.
 
clustereaaa

1 Reply

  • ValtteriN's avatar
    ValtteriN
    Community Champion
    2 years ago

    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/