Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!
Solved! Go to Solution.
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.
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.
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
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
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
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: [Color] IN {"Red", "Black", "Silver"}
I get the correct/anticipated result:
Best regards
User | Count |
---|---|
121 | |
69 | |
66 | |
56 | |
52 |
User | Count |
---|---|
181 | |
85 | |
67 | |
61 | |
53 |