Forum Discussion
Helper ILine chart based on Calendar showing values despite row level security
Hi,
I have a role in row level security set up like this:
But when I test this role, a line chart with the [CalendarYear] on the X axis is still showing all the values from the [CalendarYear] column.:
If I'm not mistaken, only 2001 and 2004 should be visible? This seems like an odd bug/security hole?
I appreciate any suggestions.
Thanks!
Hi Yamabushi ,
The default type of X-axis is Continuous , so even though you only select 2001 and 2004, the 2002 and 2003 will also be shown on X-axis . But you could not see values for 2002 and 2003.
Please change the type of X-axis from Continuous to Categorical
Output:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
speedrampsSuper User
How are you testing this ?
If you are using power BI desktop then you need to view as user?
Otherwise you hace superuser developer access and can see everything
YamabushiHi,
I'm testing this with the "View as" command in PBI Desktop. Other roles work fine. For example, if I view as this role: [Color] IN {"Red", "Black", "Silver"}
I get the correct/anticipated result:
Best regards
- Yamabushi
Hi,
I'm testing this with the "View as" command in PBI Desktop. Other roles work fine. For example, if I view as this role:
I get the correct/anticipated result:
Best regards
Hi Yamabushi ,
The default type of X-axis is Continuous , so even though you only select 2001 and 2004, the 2002 and 2003 will also be shown on X-axis . But you could not see values for 2002 and 2003.
Please change the type of X-axis from Continuous to Categorical
Output:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.- Yamabushi
Great, this works. Still, it seems strange that I see the values despite RLS being set up. If I understand correctly, the values in between (2002, 2003) are auto-generated?
Thanks