Forum Discussion
How to display Quarter summary?
See Attachment. The only issues will be if you want to display different colors for the months and quarters. I was able to add a measure in the "Cell Element" section the measure is QuarterFormat. It works with a graph because the colum section actually has conditional format icon. Also if I add zero to the blanks it adds every year on calendar.
My reference for this sample
https://www.youtube.com/watch?v=gv4kCt7vK7U
See Attachment. The only issues will be if you want to display different colors for the months and quarters. I was able to add a measure in the "Cell Element" section the measure is QuarterFormat. It works with a graph because the colum section actually has conditional format icon. Also if I add zero to the blanks it adds every year on calendar.
My reference for this sample
https://www.youtube.com/watch?v=gv4kCt7vK7U
Thank you very much. The solution is perfect. However, I would like to add a function to calculate productivity = (Sum of act)/3, but some cells in the table are showing as blank. Is there any way to fix this? Thank you.
The reason that you are getting blanks is because your measure only looking to sum anything with "ACT", so the one's blanks are under the Plan column where there is a value. but it won't divide cause is not "ACT.
you can use something like this to keep Plan emtpy, with no value since is going to duplicate colums on both ACT or PLAN. Unfortunately you can't not just keep productivity under ACT Column.
format to decimal number if need to see where you are dividing 1by3 to see .33Productivity =IF(SELECTEDVALUE(Sheet3[Status])="Act",CALCULATE(SUM(Sheet3[Value]),Sheet3[Status]="ACT")/3,"")
