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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |