A generic question, so I’m expecting a generic answer with hopefully enough info to be actionable. Perhaps a link to a video or document showing a preferred approach?
"What’s the best practice in filtering a Power BI dashboard?"
I acknowledge it cannot directly be done. I have about ten visuals from 6-7 reports and their related datasets to pin onto a dashboard. Each visual is best viewed (e.g. most useful) when filtered to a specific operating group (15 values across the company). I recognize that I may pin an entire report as a live tile, but that only serves to allow filtering on the pinned visuals from a single report.
Of course, I don’t want to create 15 versions of each report - and 15 separate dashboards from them - nor am I able to combine all datasets into one. I also don’t believe I can use PBI Desktop where each of the 6-7 published datasets are my source of a report serving as a filtered dashboard.
What would be the preferred approach here? A clever way of getting this done without a new & complex dataset?
Thanks,
Kevin