Column Chart - Define Baseline per Column

[ARugel]

Hi everyone!

I'm working on creating a new dashboard in PBI and am a relatively new user. Previously, the process to build this entailed dumping data into excel and creating manual charts from our analysis. These charts were then manually entered into ppt. It was very manual. 😑

I'm being asked to reproduce a visual from this process. In it, we can define the baseline (starting point) for each column in our chart.

Here is a sample of what I'm being asked to do along with some notes:

The result is a hybrid-type report - it's not a true waterfall nor is it a true column chart.

Is something like this possible?

Many thanks in advance!

Andrea

[lbendlin · Accepted solution]

Surprisingly this is rather simple to implement.  You can use a regular column chart (without the luxury of the colors)  

or a Deneb chart with colors.

[ARugel]

Hi @lbendlin Thank you so much for your response and sample file.

I'm looking over the file to understand the setup and it makes sense; I'm just not sure how I can take my live, queried data and implement this. Any suggestions?

Apologies, I'm quite new 🙃

[lbendlin]

if your live queried data is structured like your sample then you can use that as is.

Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.