Forum Discussion
Yamabushi
Helper I
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 [Calenda...
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.
YamabushiHelper I
Helper IHi,
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