Forum Discussion
Combine filter results into one visualisation
Fellow Power BI'ers, Our users have a requirement for a lot of ad hoc type reporting. This will be of the type ... Retrieve Sales data where FIELD_A = 'ABC' AND FIELD_B = 'XYZ' There is no ...
v-lili6-msft
Community Support
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