Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Column Chart - Define Baseline per Column

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

 

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

     

3 Replies

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      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's avatar
        lbendlin
        Super User

        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.