Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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
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
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
User | Count |
---|---|
85 | |
75 | |
73 | |
70 | |
57 |
User | Count |
---|---|
98 | |
97 | |
92 | |
78 | |
70 |