Forum Discussion
Creating dynamic quarters
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
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
2 Replies
You may refer to the following post.
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
