topic Stacked bar chart issue in DAX Commands and Tips

Stacked bar chart issue

ase — Mon, 13 May 2024 15:28:21 GMT

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,

Re: Stacked bar chart issue

lbendlin — Tue, 14 May 2024 00:27:27 GMT

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

Re: Stacked bar chart issue

Anonymous — Tue, 14 May 2024 09:17:33 GMT

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.