Stacked column chart can only have % of grandtotal?

[rpinxt]

I have this stacked column graph. It turns the quantity into % of grand total.

But as you see all is on time so I would want 100% columns in every period.

Now it splits that by period.

When I convert it to a matrix you see this behavior too:

But here in the matrix you can change "show value as"

So this is what I want. But if I change it back to a stacked columns chart again and rearange the field it is not working anymore.

I can only show as % of grandtotal.

What would be the way to fix this?

Probably need to use another measure for it?

[v-junyant-msft · Accepted solution]

Hi @rpinxt ,

If you want 100% columns in every period, you can try this visual:

Here is my sample datas:

And the final output is as below:

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

[rpinxt]

Ahh....thanks @v-junyant-msft 

Should have thought about this myself, but thanks for reminding me.

But you cannot switch between percentage view and quantity units view then.

That is ok because for now we only want to see percentages.

[rpinxt]

Trying my luck with this measure:

Qty% =

VAR __UNFILTERED_VALUE = CALCULATE([Qty], dimDate[Period] <= MAX(dimDate[Period]))

VAR __MEASURE_VALUE = [Qty]

RETURN

//DIVIDE(__MEASURE_VALUE,__UNFILTERED_VALUE)

__UNFILTERED_VALUE

So __MEASURE_VALUE will be ok but I need the unfiltered value on period.

Qty% here should for period 1 sum 8036 + 4404.

Then I can divide 8036 by 12440 and 4404 by 12440.

But I cannot get it to subtotal by period.