cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sriecke Frequent Visitor
Frequent Visitor

Toggle between fiscal and calendar year using slicer

So I have a data set of sales, but sometimes it can be viewed in a calendar year (Jan-Dec) or a fiscal year (Nov-Oct). 

I want to allow users to toggle between calendar year and fiscal year. I have a table that is just 

  • Calendar
  • Fiscal 

I have a slicer that requires the user to select one or the other. 

I have a measure:

Value Select =
VAR Selection = SELECTEDVALUE('Disconnected Slicer'[Value Selection], "Calendar")
RETURN
Selection
 
It returns the correct value based on what is being selected in the slicer. 
I also have a date table created with date, year, month, fiscal year, etc. 
I want to say that if the selected value is "calendar" then use the calendar year, else use fiscal year. 
If I create a calculated column = [Value Select], I only get calendar, even if Fiscal is selected. 
 
Is there anyway to do this? I want it so the whole report is synced based on calendar/fiscal, and there's many different variables being used that could be affected by this - so trying to avoid creating a lot of measures. 
 
I know about switch() and it only works using other measures, but not columns. 

I also would need to bring this to a column level not measure because I need the years to be on an axis. 
 
I even thought about creating two columns named fiscal and calendar, but since this was calendar table was created using DAX formula, I can't see it it query editor to unpivot it. 
Any ideas?? Is it even possible? 
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Toggle between fiscal and calendar year using slicer

@sriecke ,

 

I'm afraid slicer can only filter rows in table, slicer can't filter table or columns.

 

Regards,

Jimmy Tao

View solution in original post

1 REPLY 1
Community Support Team
Community Support Team

Re: Toggle between fiscal and calendar year using slicer

@sriecke ,

 

I'm afraid slicer can only filter rows in table, slicer can't filter table or columns.

 

Regards,

Jimmy Tao

View solution in original post

Helpful resources

Announcements
Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors