Forum Discussion
Filter pbix file data
I have two .pbix files, one that hosts the model and the other that holds the report. Is there a way to create more reports against the same model with filtered data? My use case is that the model holds data for all countries, but I want to create country-specific reports. Do I need to create models per country as well? Or can I use the same underlying model to create multiple reports against it? If yes would that play a role in performance if multiple reports are viewed at the same time?
Anonymous it is advisable to work with one model, if you want country-specific reports from the same model, you can have a report level filter to filter the country, hide/lock this so that user cannot change it, and you are good to go.
Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
4 Replies
Anonymous it is advisable to work with one model, if you want country-specific reports from the same model, you can have a report level filter to filter the country, hide/lock this so that user cannot change it, and you are good to go.
Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Anonymous check these:
Tour the report Filters pane - Power BI | Microsoft Docs
Design filters in Power BI reports - Power BI | Microsoft Docs
Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Hi Anonymous ,
You can also try to use Parameters like so:
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
