cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
vmsouza30
Helper I
Helper I

DAX FUNCTION

I have a table with the name of 10 clients, where I want to demonstrate multiple sales reports.

 

In this project I need to limit the display of data to only the client who will see their own report, ie the client can not see the details of the other data. So far so good.

 

After applying a role management using the client name filter, I need to generate a scatter chart that shows the comparison of some data from that client with the other clients, but without the current client knowing who the other clients are.

 

Is it possible to do this within Power BI or through some DAX formula? If so, how do I do this?

3 REPLIES 3
Phil_Seamark
Microsoft
Microsoft

Hi @vmsouza30

 

Yes Power BI can do this,  The feature you are looking for is Row Level Security (or RLS)

 

Here is a good blog to get you started, otherwise just search for Power BI and RLS

 

https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-rls/

 

The other decision you need to make is around letting your clients log into your tenant, or if you provide the data via Power BI embedded.

 

Is that helpful?

 

 


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Hi Phil,

 

I have already applied the RLS to restrict access to data only for a specific client (MOBILE).

 

After that, that's my problem starts, I need to have a dashboard (I need applied Graphic Scatter) where I can show comparative data with other clients.

 

Example: The customer who buys 100 items from a product at that time, I want to compare and show the customer, for this segment, whether I have more purchases or fewer products.

 

As a general rule, I have to hide the names of the other Dashboard clients.

 

It´s clear?

CheenuSing
Community Champion
Community Champion

Hi @vmsouza30

 

Can you post some sample data and the output expected in OneDrive / DropBox and post the link.

 

 

Cheers

 

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors