Forum Discussion
Solved
How to Create Dynamic Slicers switching between Fiscal year and Calencar Year
Hello Friends, I crated a power BI dashboard with "Date Table" and other fact data tables. I would like to shows the visuals by either the Calendar Year or Fiscal Year (10/1/prior year to 3/30/curr...
I have found out using the Field Parameter can solve the problem. Using the parameter paramter to create two slicers. The two will be nested, first select teh year type, and the 2nd, the specific year.
Hi @LijunChen2,
we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.
Regards,
B Manikanteswara Reddy
Hello Anonymous , I have solved the problem by creating the filters using field parameters.