Forum Discussion
Duplicate a report with new Month data
I've tried your scenario using "Parameters". If you have same structure for all three months sales data tables, add an additional field to have a source field like March for March month and April for April or anything similar unique value for each source.
Then, append those three tables into a new table using "Append Queries as New" in Power Query Editor and name it as All (For example). Use this "All" table for building your dashboard. It will show all three months data in one dashboard, but you need to have one for each.... So add parameters with values March, April, May and filter the ALL table using the parameter value.
Everytime you change the parameter value, the dashboard will change automatically. Similarly, you can have duplicate dashboards as well pointing to different parameters. Here is few screenshots (Just with sample data)....
ParametersSample SourceFilter with Parameter value
Thanks for your comment!
Today i will try it, if it works i will let you know!
Thanks
DL439204
- v-piga-msft7 years ago
Resident Rockstar
Hi DL439204,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry
- DL4392047 years agoRegular Visitor
Hi v-piga-msft
Im still bussy with it, i will accept it if the solution works.
Im not that good/fast with powerbi, just a student here :p
Best regards,
DL