Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Target, Actuals, and Budget

Hi Everyone, 

I need help. I've been working on this model for weeks. I have gotten closer to my desired result but I'm pretty stumped. Hoping I can receive a solution to this problem. I would like to keep the stacked column look.

 

1. This is the model that is from another data modeling software in which I would like to mimic in power BI.

 

 

 

2. Below is what I have thus far. As you can see I have the gray and purple portion down, however I am unsure with how to move the orange (Actual) to it's own column. Is it possible?

 

This is what I have currently. As you can see I have the purple and gray down correctly, but I am stumped in moving the orange portion (actuals) to it's own column.

  • This should be possible with a stacked column chart if you have a dimension to use on the x-axis.

     

2 Replies

  • This should be possible with a stacked column chart if you have a dimension to use on the x-axis.

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you so much, had to add some extra columns in my excel sheet and assign my data to Type, Group, and Value. Appreciate it.