Forum Discussion
How to display Quarter summary?
Hello, I am currently working with the following data table in Power BI. Is there a way to display it like in Excel?
Every three months should be represented as a separate column, calculated by quarter.
This sample PBI file: https://drive.google.com/file/d/1VCafJzdLiJV5slzd5Ssb2uFyoGazRfIm/view?usp=drive_link
Thank you.
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
4 Replies
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=gv4kCt7vK7UThank 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,"")
