How to use dynamic period for time intelligence calculations

[Anonymous]

Hi Experts,

Need your help in this. in our report page, we have a Matrix that uses the time intelligence funcions to calculate the Current quarter/Previous Quarter/Same quarter previous year. Our data gets in every last day of quarter. So the latest quarter data we have is Apr-Jun 2019. 

These calculations are working as expected using the current quarter as Apr-Jun 2019

Now we have added a Line graph - timeseries which shows quarters for last five years in X-axis. 

The requirement is when the user selects any quarter in the Line graph, the matrix should show the current quarter as the selected quarter and Previous quarter as Selected quarter minus 1. For example - if we select Jan-Mar 19 in the Line graph, then the matrix should shows values as below:

Current quarter - Jan-Mar 2019

Previous Quarter - Oct-Dec 2018

Same Quarter previous Year - Jan-Mar 2018

Please let me know how can we achieve this. Thanks.

[v-lili6-msft · Accepted solution]

hi, @Anonymous 

When you filter the data(select Jan-Mar 19 in the Line graph), the matrix value will show 

Current quarter - Jan-Mar 2019

Previous Quarter - Oct-Dec 2018

Same Quarter previous Year - Jan-Mar 2018

in the value.

Do you mean that you want the time shown in the column name in matrix as screenshot? If so, to my knowledge it couldn't achieve that dynamic column name for visual in power bi for now. 

Best Regards,

Lin