Forum Discussion
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 ...
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
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