Toggle between fiscal and calendar year using slicer

[Anonymous]

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? 

[MalJan19]

You can combine bookmarks, the selection pane, and buttons to give users the ability to toggle between seeing visuals on a calendar basis or a fiscal basis. When the calendar button is selected, the fiscal visuals would be hidden and the calendar visuals displayed. When the fiscal button is selected, the calendar visuals will be hidden and those based on the fiscal calendar will be displayed.

[v-yuta-msft · Accepted solution]

@Anonymous ,

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

Regards,

Jimmy Tao