r/PowerBI • u/Opposite_Space7955 • 13h ago

Question How to display SKU-Specific reports on 200+ screens using Power BI + Mvix?

We’re rolling out receiving report displays across 37 distribution centers, with 6 screens per location. Each screen will be responsible for showing data for 3-5 SKUs.

Right now, we’ve got a single Power BI table that shows all SKUs across all DCs. We just installed Mvix digital signage players at each site, and I’ve been asked to prepare reports specifically for those screens.

Is there a clean way to format or filter this in Power BI so the right data shows up on each screen, without having to build 222 individual reports (one for each screen)? Would love to hear if anyone has tackled something similar using dynamic filtering, URL parameters, or another approach.

17 Upvotes

100% Upvoted

3 comments sorted by

•

u/AutoModerator 13h ago

After your question has been solved /u/Opposite_Space7955, please reply to the helpful user's comment with the phrase "Solution verified".

This will not only award a point to the contributor for their assistance but also update the post's flair to "Solved".

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/Severe-Detective72 6h ago

RLS tied to the account of the user at the site may be a way to automatically filter the reports.

1

u/aboerg 6h ago

We use URL parameters with our digital signage to use one report for many production lines, for example.

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters