Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
Yamabushi
Helper I
Helper I

Line chart based on Calendar showing values despite row level security

Hi,

 

I have a role in row level security set up like this:

Yamabushi_0-1652727670481.png

 

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.:

Yamabushi_1-1652727773113.png

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!

1 ACCEPTED SOLUTION
v-eqin-msft
Community Support
Community Support

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.

Eyelyn9_4-1652931363486.png

 

 

Please change the type of X-axis from Continuous to Categorical

Eyelyn9_2-1652931063811.png

Output:

Eyelyn9_3-1652931104029.png

 

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.

View solution in original post

5 REPLIES 5
v-eqin-msft
Community Support
Community Support

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.

Eyelyn9_4-1652931363486.png

 

 

Please change the type of X-axis from Continuous to Categorical

Eyelyn9_2-1652931063811.png

Output:

Eyelyn9_3-1652931104029.png

 

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

Yamabushi
Helper I
Helper I

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:

Yamabushi_0-1652728419775.png

 

I get the correct/anticipated result:

Yamabushi_1-1652728504919.png

 

Best regards

speedramps
Super User
Super 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

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:

Yamabushi_1-1652730817841.png

 

 

Best regards

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.