Sharing Reports with external users (problem with values)

[Anonymous]

Hi guys,

Situation:

Within my company I created a dashboard to see the Market Share volume % per type of Product Category

Example:

Category 1: Beauty & Perfumes

In this dashboard you can see the relative market share of each brand comparing to the others.

Based on a measure that compares (Items sold of each Brand / Total Items Sold in that category)

Context:

I have to share this report with the brands and I have to include the relative percentage of their market share inside each category.

Problem:

The report that they have, they can only have access to the values from their own brand,so I have an issue on the % seen of their brands because now they are comparing the market share with their own brands inside same category.

Question:

There's anything that I can do in order to resolve this issue?

I can't give them access to values from other brands, but I would like to give them access to their relative % comparing with other brands.

Thanks a lot

Diego

[AilleryO]

Hi,

I would consider creating a preconsolidated table with CALCULATETABLE or SUMMARIZE functions, and calculate your shares within that table.

Then you will apply security on that table with the shares already calculated with the level of details you want.

Hope it helps, is it clear enough ?

[v-zhangti]

Hi, @Anonymous 

You don't want them to get the value of other brands, and this can be achieved by setting up RLS. 

Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles. In the Power BI service, members of a workspace have access to datasets in the workspace. RLS doesn't restrict this data access.

This is the relevant document, hope to help you: https://docs.microsoft.com/power-bi/admin/service-admin-rls 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hello @v-zhangti 
The problem is that market share is calculated based upon the data of the other brands. Activating that feature, they will not be able to access the data from other brands, but also my Market Share Calculations will be ruined right?
So there's any other solution?

Thanks

Diego