Seasonal Date Issue

[awitt]

Hello all,

I have a date table and an orders table that are related and my date table has the standard date table things along with a column for season (Spirng, Summer, Fall, and Winter), a SeasonValue column (1 , 2 , 3 , 4) and another for "Term" which is a combined Season + Year. This Term column is what the end user is selecting. 

My question is, I'd like to have a line chart that shows the results of of the only the relative seasons when the user selects a specific Term. So if the selection is "Summer 2020" from a filter, the results on the line chart would be the orders data from Summer 2017, 2018, 2019, and then 2020 with the other three seasons not included. 

Thoughts?

[v-lionel-msft]

Hi @awitt ,

"I have a date table and an orders table that are related and my date table has the standard date table things along with a column for season (Spirng, Summer, Fall, and Winter), a SeasonValue column (1 , 2 , 3 , 4) and another for "Term" which is a combined Season + Year. This Term column is what the end user is selecting. "

Please give sample data for these two tables.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[pranit828]

Hi @awitt 

I would create a filter on only season column and not on season year.

[awitt]

@pranit828 That's not what the user wants. If I didn't have to have the Term selected then I wouldn't have the issue...

[amitchandak]

@awitt , Can you share sample data and sample output in table format?