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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
akhaliq7
Post Prodigy
Post Prodigy

Single select slicer, D-RLS and user has no data for the default selected value in the year slicer

I have a report whereby I have configured the dynamic row level security, I also have a year slicer which is set to single select, when I view as a certain user who has no data for the year it is set to 2022 then I get blanks showing in my report however when as that user I change the year value to 2021 then I get values and the year 2022 disappears from the slicer, to remove this bug from my report what should I do?

1 REPLY 1
amitchandak
Super User
Super User

@akhaliq7 , I doubt as of now you will be able to control that as of now based on RLS. As RLS works can control measure and as of now you can not use a measure to default visual. I saw a tweet that is default date Idea is in WIP now

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors