Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Chiccada
New Member

Switch between data tables in the same dashboard

Hello,

 

  Sincerest apologies if ths question has been answered already, but after a fair bit of search nothing seems to quite answer my question exactly.

I am looking to be able to switch/toggle between two different data tables within the same dashboard, ideally by selcting a radio button or slicer based on the date column information. Both data tables are set up wiith exactly the same column headings. One table relates to 17/18 data and the other is 18/19 data.

I am hoping this is possible.

 

Thank you for your time.

1 ACCEPTED SOLUTION
adityavighne
Continued Contributor
Continued Contributor

@Chiccada 

I think you need both views 17/18 and 18/19 for reference. 

1) keep as it is related to common date table and you can show data in separate columns. comparing exact same date range of the previous year

OR

2) Use the toggel image with selection pane and bookmark. you need to hide one data to view another

View solution in original post

2 REPLIES 2
adityavighne
Continued Contributor
Continued Contributor

@Chiccada 

I think you need both views 17/18 and 18/19 for reference. 

1) keep as it is related to common date table and you can show data in separate columns. comparing exact same date range of the previous year

OR

2) Use the toggel image with selection pane and bookmark. you need to hide one data to view another

Hi, thanks for the response. I will give this a go and feed back.

 

Thank you.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.