Forum Discussion
Combine filter results into one visualisation
Tom,
Thanks again for your reply.
Mmmm, not quite. Still suffers the same issues as the previous methods I've tried (though will be good for another couple of scenarios we have), It still depends on what fields you choose in the visualisation (usually just a table) as to results (records) are actually shown.
Regards
Basil
Community Supporthi, BPrivitera
You may try to use dynamic row level security with Analysis services tabular model,
So the user doesn't have to write a measure to filter the data.
Reference:https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-row-level-security-onprem-ssas-tabular
https://docs.microsoft.com/en-us/power-bi/desktop-rls
Best Regards,
Lin
Lin,
Thanks for replying.
Unfortunately, the filtering that needs to happen is quite Ad Hoc so I don't think implementing RLS will be my answer as this will start to affect other reports that they should be able to run.
I'll keep looking for an answer but perhaps PowerBI is not the answer for this one.
Regards
Basil