Creating dynamic quarters

[MagnusSthlm]

Hi!

My customer has four charts, one for each quarter. They want to select Year and Quarter from a dropdown for example 2018-Q4 as start quarter. The second chart should then show show data from 2019-Q1 and so on. 

I tested several things to achieve this but I'm stuck. I created four columns in my date table and they all show the correct year and quarters. If the first quarter is 2018-04 the second quarter is 2019-01. But when I select the Year Quarter on the dropdown all the charts get filtered on the same data. 

I can't use a measure here or can I? A measure can't be on a legend. If I could I could use Calculate and ALL to remove all filters.

Anyone done this before?

/Magnus

[v-chuncz-msft]

@MagnusSthlm,

You may refer to the following post.

http://community.powerbi.com/t5/Desktop/Split-amp-filter-data-from-one-table-into-multiple-based-on-...

[MagnusSthlm · Accepted solution]

Hi! 

Thanks for your reply. I actually solved it yesterday.

In my date table I created a Year - Quarter column. Then I manually created a new table, called it Year Quarter Selector. It had four columns, first column is the year - quarter the user selects. Then the next column is the following year - quarter. So first could be 2018-Q4 and the second would be 2019-Q1 and so on. 

Then I created  four measures that used SELECTEDVALUE from my selector. I used them as filters in the chart. 

I can clarify with some code if someone is interested.

/Magnus