Changing matrix row content by single user / user group

[_FB_]

Hello everybody,

this is my first post here and I hope i could get helped somehow. Thanks in advance! I am a PBI beginner...

I am looking for a way to change a matrix row content by user / user group. This means in detail:

We have main customers / accounts, this main customers / accounts can have one or more sub-accounts. Both parameters are connected in the data source. For a management view it is sufficient to show e.g. the sales of the the main customers / accounts. For our sales managers, it is necessary to see the sales of the sub-accounts.

Can I somehow combine two views in one visual / matrix that will dynamically change by the user / user group which is accessing the report?

If any questions left, pls let me know.

BR

FB

[_FB_]

Hello again,

any other ideas to answer my question / solve my problem?

If additional explanation is necessary, pls let me know.

For me this issue is very important because i am currently maintaining two identical reports (main and sub accounts) to generate the mentioned seperated view.

BR

_FB_

[bhanu_gautam]

@_FB_ , Yes you can do this using  Row-Level Security (RLS) and dynamic measures to control what data is shown to different users or user groups.

Here is a video for RLS

https://youtu.be/M5K_jKPxdqI?si=O8UzM7ACTZG-LgAJ

[_FB_]

Hello bhanu,

thanks for answering. To my opionion this is not what i am looking for. Because:

I don't want to choose another parameter existing in a table / visual (Filter), I want to replace the parameter main account by the sub-account (View) when a sales manager opens the report. By default, the report should show the main accounts - if possible in each created visual.

BR

Fabian

[bhanu_gautam]

@_FB_ , You can achieve that with RLS , you can also use bookmarks but it will not be dynamic as per user but in RLS you can do that by creating custom measure like

SalesMeasure =
IF(
ISINSCOPE('UserRoles'[RoleName]),
SWITCH(
TRUE(),
'UserRoles'[RoleName] = "Management", SUM('Sales'[MainAccountSales]),
'UserRoles'[RoleName] = "Sales Managers", SUM('Sales'[SubAccountSales]),
BLANK()
),
BLANK()
)

If not RLS than you can explore bookmarks create one button and two bookmark one for accounts and one for subaccounts then hide the other visual at that bookmark and do similarly for other 

Link for bookmark - https://youtu.be/XSphZtgiEDI?si=4_h73MBV9btYVhYQ

[_FB_]

Hello @bhanu_gautam ,

thanks again for answering.

I understand your presented "SalesMeasure", but I do not think this is a solution. To my opinion the problem is that I want to show a different row content in column #1 in one matrix visual, e.g. sales revenue by either the main accounts or sub accounts (not both!!!), dynamically depending on the user / user group.

Thus someone from General Management should see the sales revenue listed by main accounts, a sales manager should see the sales revenue listed by sub accounts he/she/it is responsible for. And this should take place in only one (same) matrix visual.

BR

_FB_