Forum Discussion

nanma94's avatar
nanma94
Helper III
8 years ago

dynamically show X axis when applying security

I have a report that have several bar chart visuals. The X axis is a sales hierarchy - country - area - region - territory, and y axis is sales revenue. 

 

This report has row level security setup so when region manager comes in, he/she only sees their own region. However, since the visual is defaulted at country level, now when region manager (mid south region in the west area) login in, he sees the bar chart showing US(100). The number 100 is correct for his regional sales, but the x-axis is so confusing. The user has to drill down a level from US to west, he still sees West(100); drill down 1 more level, the chart x-axis label finally shows the correct level which is at the region level .

 

Is there a way when diff levels logins in, the chart can show directly his level? I know I can probably create multiple versions of the reports at country level, area level, region level, etc. But the maintenance cost is too high. 

 

Thank you so much!

NM

Need Help

2 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    8 years ago

    Hi nanma94,

     

    Based on my test using the data like this, I find that it’s not possible to meet your requirement. Could you please share your sample data to me ?

     

     

    Regards,

    Frank

     

    • nanma94's avatar
      nanma94
      Helper III
      8 years ago

      v-frfei-msft Frank, 

       

      I shared a PBIX at https://drive.google.com/open?id=1zfcazAmqFAv5ksBrnfaJvPZ66QqLZVYV

       

      I have row level security but as you see, when WR1 (West area Region1) logs in, the sales# is correct, but the X axis label starts with country, you can drill down to area, then to region, finally to customers. Whats desirable is to jump directly to region level and show WR1, or the next level, its customers.   

       

       

      Thank you so much for looking into this for me!

      NM