Show all quarters in Matrix

[rosscortb]

Hello, 

In that attached, do you know how i would show all quarters as it is only showing current, so I can see any increase/decrese in  the measures please?

Thanks

Ross

[v-easonf-msft]

Hi , @rosscortb 

It’s not very clear.

Please check  whether any other   filters has be  applied to your original data table. 
You can take  a try  to "Show Items with No Data" on some matrix  values fields.

Best Regards,
Community Support Team _ Eason

[amitchandak]

@rosscortb , ax data is expended in your screenshot can see what all qtr you are getting.

If you have a date and want to get diff between qtrs then try like 

QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(('Date'[Date])))
Last QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(dateadd('Date'[Date],-1,QUARTER)))

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.