Powerbi Stacked Bargraph modeling

[Anmolgan]

I am looking to create a data model where there will be sales for past 5 years of various 5 comapnies that will contain some users of each, and will be creating a stacked bargraph that will contain sales of a specific user with stacked bar graph that will contain aggregated sales of each company on each year. So if user a logins he would see his company sales with comparison to aggregated sales of all the companies of each year, how something like this can be achived.

[v-jiascu-msft]

Hi @Anmolgan,

There could be two approaches.

1. Create a measure like this. You can add more conditions for other users.

PerUser =
IF (
    USERPRINCIPALNAME () = "user0@email.com",
    [Company 1],
    IF ( USERPRINCIPALNAME () = "user1@email.com", [Company 2], 0 )
)

2. Using RLS. Please refer to power-bi/service-admin-rls and power-bi/desktop-rls.

Best Regards,

Dale