Stacked Column Chart - Displaying Max & Carry Over Values

[Anonymous]

Hello,

I have a question about creating a measure for a specific visualization in Power BI. I currently have the stacked column chart, where the stacked columns are 'Cost' for different 'Type' of expenses each month. I've also included a line value (made using a measure) of the maximum 'Available Income' each month. The visualization I want to create includes 2 parts:

1. Display total column values only up to max line
2. Carry over excess values above the max line

EDIT - I was able to get the results in Excel and just display the results in Power BI visualization for a more straightforward approach instead of using complicated measures.

Thank you!

[lbendlin]

for the first part you will have to define how the different categories should be cut to stay under the green line.  Proportionally?  In a particular order? In which order?

The "carry over"  part can get very (very) complex very quickly especially when the carry happens across multiple successors.

[Anonymous]

Thank you for your response!

I realized I can easily get the results in Excel instead of creating more complex measures in Power BI.

I appreciate your time and help. 🙂