Percentage in stack bar with MTD & YTD Dimension

daisy — Tue, 29 Dec 2020 05:14:46 GMT

Hello Everyone:

I have a 2 Financial Year data pool like below:( DR Result only have 4 figures :1,2,3,4)

I want to create a percentage stack bar with MTD & YTD Dimension like below:

Current Situation:

Now I use valuelist as the dimension, but it's vvvvvvery complex!

Dimension: =ValueList('FY20','P1','P2','P3','P4','P5','P6','P7','P8','P9','P10','P11','P12','FY21')

Measure: there's 4 measures all use pick(match(valuelist()),,count({<DR Result={'1'}>})/count()), which will write a lot of rows!!!

My Target:

Dimension1: Period

Dimension2: DR Result

Measure: count({<FY={'FY21'}>}[DR Result])/sum(total <Period> aggr(count({<FY={'FY21'}>}[DR Result]),Period,[DR Result]))

So my question is that is there a way to make it easier to show the percentage stack bar with MTD & YTD in the dimension?

Thanks so much in advance!

topic Percentage in stack bar with MTD & YTD Dimension in App Development