Seasonality report

[Anonymous]

Hello, 

I am trying to prepare a report where I need to see the items that has the month value as 1, Can someone suggest me how I can do that. Here's an example of the report

[Greg_Deckler]

@Anonymous Use the Filters pane and filter for 1?

[Anonymous]

Thank you, I tried it earlier but it only showed the result for the item in the particular month and removed all the others. For eg; i filtered the month Feb to show 1 and it removed all the other items that had 1 in Oct, Nov or dec etc 

[Anonymous]

Hi @Anonymous,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng