Forum Discussion

ase's avatar
ase
Frequent Visitor
2 years ago

Stacked bar chart issue

Hi all, 

 

I have the following issue:

 

 

I want to keep the total at 7.9m and the other 2 categories to take up from the total. At the moment they just add up, so the grand total becomes 11m.  

 

Is it possible to keep the budget at 7.9m and get the other 2 bars "eat up" the budget and show much is already spent?

 

Thank you!

 

Kind regards,

B

 

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Introduce a "Remaining Budget" column and use that instead.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi ase ,

     

    There is no direct progress bar feature in power bi, but you can create two measure:

    An attachment for your reference. Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.