Forum Discussion

powerbimaruser's avatar
powerbimaruser
Regular Visitor
7 years ago

Display Hierarchy based on User

Hi All,

 

In our project we have the following scenario

 

Hierarchy:

Country -->Region-->Territory-->BrickArea-->Brick

 

the users are

Country Manager

Region Manager

Territory Manager

Sales Manager

 

sales is going to be the fact.

 

we are displaying the country wise sales in stacked column chart. when country manager logs in he will see at country level and he can dril down to all the next levels.

 

when regional manager logs in, then hierachy should start at Region level not at the country level, then user can drill down to all the next levels.

 

Same thing applicable to Territory and Sales as well.

 

Can we do this in a single visual in Power BI?

 

Please help us..

 

Thanks..

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi PowerBIMarUser,

     

    Yes, You can achieve this in Power BI by having hierarchy created for all the Region values.

     

    Hierarchy should be Country -->Region-->Territory-->BrickArea-->Brick

     

    Post that, you need to have Row Level Security to be implemented for this report of having a condition for users like Designation like Country Manager, Region Manager, etc..

     

    Designation = Country Manager

     

    This will be automatically enabled users to filter data while he logs in to PBI.

     

    Regards,

    Pradeep

  • Nishantjain's avatar
    Nishantjain
    Continued Contributor
    7 years ago

    powerbimaruser 

     

    I don't think that is possible to dynamically change the level of a hierarchy in Power BI based on a user. You can restrict data every users sees but the layout of the visual is static. 

    I am not aware of any way to achieve this

     

    Thanks