Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

How To Replicate This Graphic from Excel into PBI

I need to recreate this chart in Power BI, but I'm having trouble adding another measure within the columns to achieve the desired result. The closest I have come is using the "Line and Stacked Column Chart" option, but it only places a point. As shown in the image below, what I would like is to replicate this visual.

 

The goal is to show a comparison between the expected and actual values for each category, with each displayed side by side within the columns. Additionally, at the end of the period where actual values are not available, only the expected values should be shown. This visualization is logistic in nature.

 

The visual i wanted to replicate

 

 

 

The visual i have managed to create so far

 

 

 

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, Anonymous 

    Thanks for Greg_Deckler positive reply. Here's the addendum, you can find this visual object in the Visualization Pane.



    Best Regards,
    Yang

    Community Support Team

     

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion

    Anonymous Looks like a Line and stacked column chart to me.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi, Anonymous 

    Thanks for Greg_Deckler positive reply. Here's the addendum, you can find this visual object in the Visualization Pane.



    Best Regards,
    Yang

    Community Support Team