Stacked bar chart with 2 Measures as Value and Axis

[jcloss13]

Good Morning,

I am assuming that this is something very simple but I am new to Power BI and can't quite get past this one. I am trying to make a simple stacked chart with the Legend being a column that holds "Yes" and "No" and I want to see a column for the Count % Total and a column Balance % Total. 

 Is there an easy way to do this? 

Thank you,

Jordan

[v-ljerr-msft · Accepted solution]

Hi @jcloss13,

If I understand you correctly, I don't think there is an easy to to it currently. You may need to add you a new table(let's call it "NewTable") with a column(let's called it "NewColumn") which has two values("Count % Total", "Balance % Total") first, then use this column as Axis on the stacked bar chart.

You will also need to create a new measure to calculate "Count % Total" and "Balance % Total" according to the current Axis. Then use this measure as Value on chart. The formula below to create the measure is for your reference.

New Measure =
IF (
    HASONEVALUE ( NewTable[NewColumn] ),
    IF (
        VALUES ( NewTable[NewColumn] ) = "Count % Total",
        [Count % Total],
        [Balance % Total]
    )
)

Regards