cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 192 members 1,801 guests
Please welcome our newest community members: