Multiple models

[Anonymous]

I've three separate pages one for display, one for search and one for social

Ideally we have want filters to work across all 3 pages, so if you select eg UK country on one page, you see UK filtered on all other pages.

We have one model for all three which is very table heavy 

Be easier to follow if w had three separate models.

Please advise on good material/videos I can read up on how to create three separate models in the same dashboard

Thanks!

[v-alq-msft]

Hi, @Anonymous 

I'd like to suggest you use page level filter or sync slicer to filter three separate pages.

About the three separate models, there are eight different data reduction techniques. Please refer to the article .

• Remove unnecessary columns
• Remove unnecessary rows
• Group by and summarize
• Optimize column data types
• Preference for custom columns
• Disable Power Query query load
• Disable auto date/time
• Switch to Mixed mode

In addtion, It is suggested to use a star model. Star schema design and many related concepts introduced in this article are highly relevant to developing Power BI models that are optimized for performance and usability. You may refer to the article .

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

You can use report-level filter on filter pane. Or you can have a filter on one page and copy it on other pages, it will ask for the option to sync, click ok. Then choose a value on one page.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers

https://community.powerbi.com/t5/Desktop/Syncing-Filters-carries-across-to-unselected-pages/td-p/432...

https://docs.microsoft.com/en-us/power-bi/power-bi-report-add-filter

https://community.powerbi.com/t5/Desktop/Difference-between-page-level-filter-report-level-filter-an...

https://www.tutorialgateway.org/power-bi-page-level-filters/

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin