Forum Discussion
Multiple options for slicer
You can Create a parameter where you put both Fiscal-YearMonth and Calendar-YearMonth for example. Once you create the parameter power bi will create a slicer as well (if the option is selected):
Then you can use the parameter you have created in your chart and it will switch once you change it in the slicer.
Thank you. I have used the parameter for other visuals, where the x-axis is the calendar or Fiscal year. However, what I am wanting is the ablity to select various years in a chart. For example if I have a bar chart of total sales (y-axis) by region (x-axis), I want the abliity to have a slicer on the side where I can pick a specific years, but I also want the ablity to toggle between calendar or fiscal year without having to create 2 slicers, one for Calendar year and one for Fiscal year. Is that possible? Thanks.
