Forum Discussion
Problem with Cumulative percentage
Hi sudhakar111,
But i need to show it as 2016-Apr,2016-May and so on in that order.
It is only showing in alphabetical order like 2016-Apr,2016-Aug and so on.
You should be able to follow steps below to get this work. :smileyhappy:
1. Select "Year Month" column.
2. Click Sort by Column under Modeling tab.
3. Select "Month Year"
Regards
Hi sudhakar111,
After looking into your shared pbix file, I find that you're using a calculate column to calculate the percentage. So the percentage will be added up at the 1st and 2nd levels.
In this scenario, you should create a measure instead to calculate the percentage, then it should work as expected in the Matrix preview.
Difference % Measure =
DIVIDE (
SUM ( Merge1[Budget] ) - SUM ( Merge1[Actual] ),
SUM ( Merge1[Budget] )
)
Regards
Thanks a lot v-ljerr-msft, it worked perfectly.
i posted one other issue on the same sample data.
The cross tab has year and month.If it is all numeric it works fine.
But i need to show it as 2016-Apr,2016-May and so on in that order.
It is only showing in alphabetical order like 2016-Apr,2016-Aug and so on.
Hi sudhakar111,
But i need to show it as 2016-Apr,2016-May and so on in that order.
It is only showing in alphabetical order like 2016-Apr,2016-Aug and so on.
You should be able to follow steps below to get this work. :smileyhappy:
1. Select "Year Month" column.
2. Click Sort by Column under Modeling tab.
3. Select "Month Year"
Regards
Thank you so much v-ljerr-msft, it works perfectly. The mistake i made was trying to sort on the same column.