Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Create action on Filter values in Power BI

 

Hi,

 

This is Poonam. I am very new to Power BI. I have one below requirement.

I have one sheet in Power BI on which I have created graphs and I have 'Quarter-Year' filter. Now the requirement is, User want me to create filter which will have below values:

1) Current Year View: Which will show graph for 2018 year Quarter Year values.

2) Next Year View: Which will show graph for 2019 year Quarter Year values.

3) 4 Rolling Quarter : Which will show graph for next 4 quarter Quarter-year value.

4) All Year View: Which will show graph for all Quarter Year values.

 

I could achieve that by creating buttons and action on it. (By calculating different measures for each view by by creating action on button) But not sure how I can achieve that by creating above 4 filter values and action on it.

Can anyone please help me on that?

Thank you!

 

Regards,

Poonam