Quarterly Data Doesn't show up properly
I'm trying to create something similar to the illustration on the left. However, the illustration on the right side is what I've achieved so far. The current problem that I have is regarding the quarterly data. As you can see that the selected MonthYear on the slicer is Dec-20 Which is the 4th quarter in a year. The expected result should contain the sum data of Q1, Q2, Q3, and Q4. However, what I have right now with my measure it could only return value from Q2, Q3, amd Q4. It's even worst that if I select JAN it doesn't show anything at all. I hope that someone could take a look at the sample file I've created with dummy data and help me understand what's going on and why my code doesn't work. If someone could come up with a better on how to create view in a database or change data model to make it looks like the illustration on the left side it would very be helpful. If not then just fixing the already existed visualization to display all Quarter data would be very appreciated as well. Slicer = Dec-20 On the left side it display values of Jan until Dec which is the expected result. However, as soon as I remove the MonthYear column from the visualization some data became missing. For example, data for JAN is gone and so on. Thank you in advance! 🙂 Here is the sample PowerBI file with some mock-up data and pre-created DAX measure. https://www.dropbox.com/s/401l8b3mmowoxbf/Sample.pbix?dl=0
