Forum Discussion

charleshale's avatar
charleshale
Continued Contributor
5 years ago
Solved

Stacked Column Visual -- Making it Overlap within the chart, Not Total (Revenue, EBITDA for example)

Anyone have any ideas for how to do a stacked column visual easily where the Total is the largest data value and the smaller data values shows as components of that?

 

An example would be how to easily achieve the chart below where I want to show revenue and ebitda, but have ebitda dispay as a part of the revenue line item instead of the 2 getting summed together.   For example: if a quarter's revs are 7.5m and EBITDA is 1.6m.

 

DESIRED OUTCOME:

I'd like the chart to total 7.5m and show EBITDA as 1.6 of that instead of the total totalling 9.1.

 

NOT DESIRED OUTCOME - but the one I can do:

 

 

Of course, I know I can hack my way to this through measures -- but it'd be more elegant if I dont do that work around.   Surely there's an easy setting I am simply missing despite the fact that I spend most of my life on PowerBI!!!     Thank you! 

 

 

 

Need Help

3 Replies

    • charleshale's avatar
      charleshale
      Continued Contributor
      5 years ago

      amitchandak Thanks for the reponse.  That's still a workout though, isnt it?   Because look at the Y axis.  In your example, left column, the 2nd data set still adds to the first instead of being a subset of it.   Ideally there would be a setting in stacked charts for whether the items should be totaled (eg Sales Expense  $100  + Marketing Expense $80 stack to total 180) vs a subset (Revenue = $100, EBITDA is 10 -- graph show with EBITDA being ~10% of the stacked column line of Revenue, total 100 instead of 110)    

  • Icey's avatar
    Icey
    Community Support
    5 years ago

    Hi charleshale ,

     

    Create a measure to show "revenue - ebitda" and then use this measure and "ebitda" to create visuals like so:

    Revenue - Ebitda = SUM('Table'[revenue])-SUM('Table'[ebitda])

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.