I am stuck one something would really appreciate your take on it
I am building a report that have multiple regions, and I want to use PowerBI row level filtering so certain users in each region will see the information about their region only.
Everything works as expected. The issue I’m having is that I have a pie chart that shows the percentage of sales for that region against the total sales.
Since I am using row level filtering the results sets for the other regions get filtered out and therefore the total sales will not be correct and the pie chat will display wrong results.
Row level filtering was one of the solutions I was thinking of to achieve this.
What is the best way to achieve the region segregation without creating multiple reports.