how to create a selector (slicer) for multiple datatables

[Ralf123]

Hi,

I have multiple datatables (system_1, system_2 etc) with the same columns (with different data in them) and want to make a graph showing the data of one of the columns. Now I would like to have a selector (slicer) in which I can select one of the datatables (system_1 or system_2 etc) and the data of the selected system database will be shown in the graph.

Is this possiblea nd how do I do that?

I don´t want to merge the tabletables, too many with too much data.

gr.

[v-shex-msft]

Hi @Ralf123,

If these tables contains relationship with 'both' cross filter direction option, you can drag the key as the source of slicer to filter multiple tables.

In addition, if they not contains the relationship, you should manual merege these related columns to new table and build the relationship, then you can use the merged table columns to filter on these tabels.(you can also refer to cs_skit's sample, it seems well)

>>I don´t want to merge the tabletables, too many with too much data.

You not need to merge whole tables, you only need to merge the related columns.

Regards,

Xiaoxin Sheng

[cs_skit · Accepted solution]

This should be exactly what you need:

http://community.powerbi.com/t5/Desktop/Stacked-and-Line-Chart/m-p/205836#M90680

it only merges the category values for the slicer