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 All
I am a new user to Power BI and would really appreciate some help. I have imported and transformed an Excel spreadsheet based on a specific date (24052022 = DDMMYYY). I have now imported an additional spreadsheet based on the 14062022. How do I create a linkage to enable my PowerBI visuals to be pointed at either dates based on some sort of dropdown?
Thanks in advance.
Regards
Gavin
Solved! Go to Solution.
Hi @grthompson76 ,
You can try something like below. I have created two sample tables named 14062022 and 24052022.
Easiest way is to add a column to each table that contains the query name. You can do this manually by adding a new column, or dynamically in Power Query by creating a parameter DDMMYYY, and adding a custom column = DDMMYYY
Next, perform a union operation in DAX to append these two tables. You will now get a single table with data from both tables, and an additional column that identifies the file.
Now in a blank table, add fields from the new union table, and use the filename as a slicer. When you select a filename, only data from that file will be filtered out and displayed.
Kind regards,
Rohit
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂
Hi @grthompson76 ,
You can try something like below. I have created two sample tables named 14062022 and 24052022.
Easiest way is to add a column to each table that contains the query name. You can do this manually by adding a new column, or dynamically in Power Query by creating a parameter DDMMYYY, and adding a custom column = DDMMYYY
Next, perform a union operation in DAX to append these two tables. You will now get a single table with data from both tables, and an additional column that identifies the file.
Now in a blank table, add fields from the new union table, and use the filename as a slicer. When you select a filename, only data from that file will be filtered out and displayed.
Kind regards,
Rohit
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |