How to turn tables based on dates into selectable date fields for your visualisations

[grthompson76]

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

[rohit_singh · Accepted 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! 🙂