Forum Discussion
Power BI: Displaying Anonymous Competitor Data with Store-Specific Filters on SharePoint
The situation I'm grappling with is as follows: I've designed a dashboard for a client that displays data from 150 distinct stores. These stores are owned by 55 individuals, with some of them having...
You can also try another way, try prepare more complex model in Power BI which meets your requirements.
E.g. You can have full detail data in model, and use RLS rules which are applied during interactive queries of users. From this data you can create second calculated data table in model (during calculation RLS is not applied), which will be aggregated and anonymized, without any RLS, and will be used for comparasion. But all of it depends on another requirements, which I don't know.