topic Re: Stacked Column Chart - Displaying Max & Carry Over Values in Custom Visuals Development Discussion

Stacked Column Chart - Displaying Max & Carry Over Values

Anonymous — Mon, 06 Jun 2022 22:36:07 GMT

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!

Re: Stacked Column Chart - Displaying Max & Carry Over Values

lbendlin — Mon, 06 Jun 2022 19:34:55 GMT

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.

Re: Stacked Column Chart - Displaying Max & Carry Over Values

Anonymous — Mon, 06 Jun 2022 22:34:31 GMT

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