Forum Discussion

Yamabushi's avatar
Yamabushi
Icon for Helper I rankHelper I
4 years ago
Solved

Line 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...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

speedramps's avatar
speedramps
Icon for Super User rankSuper User
4 years ago

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

  • Yamabushi's avatar
    Yamabushi
    Icon for Helper I rankHelper I
    4 years ago

    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