Forum Discussion
Stacked Column Chart - Displaying Max & Carry Over Values
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:
- Display total column values only up to max line
- 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!
2 Replies
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.
