Forum Discussion
Helper ISelect table containing the right data with dropdown menu
hi, TommyMossberg
Do you mean that different progress periods are in different tables or data source?
If so, you could try this way:
Step1:
In different progress periods tables, add a tag column, eg. "period 1" for progress period 1 table "period 2" for progress period 2 table, etc.
Step2:
Then append the different progress periods table into one table.
http://radacad.com/append-vs-merge-in-power-bi-and-power-query
Step3:
Create the report based on the new append table.
Step4:
Use tag column as a dropdown slicer.
If not your case, please describe it with sample data.
Best Regards,
Lin
Community Supporthi, TommyMossberg
Do you mean that different progress periods are in different tables or data source?
If so, you could try this way:
Step1:
In different progress periods tables, add a tag column, eg. "period 1" for progress period 1 table "period 2" for progress period 2 table, etc.
Step2:
Then append the different progress periods table into one table.
http://radacad.com/append-vs-merge-in-power-bi-and-power-query
Step3:
Create the report based on the new append table.
Step4:
Use tag column as a dropdown slicer.
If not your case, please describe it with sample data.
Best Regards,
Lin
TommyMossbergThis might be a solution :)
I'm trying to do this in PowerBI but I'm getting a lot of errors. If I can solve them I'll mark this as "Accept...." otherwise I'll come back with more info.