Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have two (soon to be more) data sets which show daily data for different months, they are linked via a relationship on the date and can be shown in a graph together. I want a slicer that will select all the data from one data set or another so you can choose which months data you want to see. THere are 4 pieces of data for each month. Attached pictures of the data, can anyone help me do this?
Thanks
Solved! Go to Solution.
Hi @Anonymous
You may import all the data sets and then use 'Append queries as new' in query editor for them. You may use this new append table's date as slicer. Here is the article about this feature for your reference.
Regards,
Cherie
Hi @Anonymous
You may import all the data sets and then use 'Append queries as new' in query editor for them. You may use this new append table's date as slicer. Here is the article about this feature for your reference.
Regards,
Cherie
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |