Slicer to switch between 2 fact tables

[PshemekFLK]

Hello,

I have 2 fact tables - "bookings" and "shipments". In the report I would like to easily switch between the two. The easiest way seem to be appending the two fact tables and changing source column to "bookings/shipments" and make a slicer based on that column.

I understand however that appending 2 fact tables is not desired due to significant reduction of calculation speed.

Is there a way to create a slicer between 2 fact tables without having to append them?

[Greg_Deckler · Accepted solution]

Well, the performance issue you cite may or may not be a factor. Depends, how many total rows?

You could definitely do this using the Disconnected Table Trick and a measure that determines which calculation to make depending on the slicer selection. Would need sample data and such to see if it was feasible but yes, in concept you definitely can. In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick...

[v-gizhi-msft]

Hi,

Please try to use Sync Slicers.

See this:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers#sync-and-use-slicer... 

Hope this helps.

Best Regards,

Giotto Zhi

[Greg_Deckler · Accepted solution]

Another thought, you could do this with buttons and bookmarks instead of a slicer.

[PshemekFLK]

The appended table would have 1,200 000 rows so quite a lot.

I was thinking abut bookmarks but this would mean a lot of tables beneath each other (since I'm already using bookmarks for other switches)

Would disconnected table solution work for this model?:

Thanks

[Greg_Deckler · Accepted solution]

Well, the performance issue you cite may or may not be a factor. Depends, how many total rows?

You could definitely do this using the Disconnected Table Trick and a measure that determines which calculation to make depending on the slicer selection. Would need sample data and such to see if it was feasible but yes, in concept you definitely can. In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick...