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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
raviteja_prathi
Frequent Visitor

Setting the Default Value of a Slicer

We are using PowerBI and embedding reports for users in our application using PowerBI javascript API. We have a role for RLS in the reports and we are using Direct Query to connect to our on premise oracle instance. 

 

The problem we are facing is we have slicers in the reports and there is no option to select the default value of the slicer. When the user first accesses the page all the visualizations are loaded fully without any filter. This is resulting in slowing down of the report rendering. We are also not able to select any default value for the slicer because the data in the slicer is different for different users. If we can make the selection in a slicer mandatory or loading the slicer with defaults probably using a Javascript API would help but I was not able to find any workaround in order to achieve the same.

 

Any suggestions on how to handle this scenario would be helpful. 

 

Thanks

2 REPLIES 2
v-micsh-msft
Employee
Employee

Have you checked the following article?

Embedding with Row Level Security

https://docs.microsoft.com/en-us/power-bi/developer/embedded-row-level-security

 

Further, Power BI JavaScripts API allows to apply fitlers directly to the report, page or visual levels:

https://github.com/Microsoft/PowerBI-JavaScript/wiki/Filters

 

Leaving Default value for a slicer is currently not supported, see the idea below:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7162004-default-selected-slicer-o...

 

Regards,

Michael

Hi Michael,

 

Thanks for your reply.

 

We need the end user to select the values they need in the slicer. We are not exposing the filters to the users. So we cannot apply filter using PowerBI Javascript API to the reports. What we need is default selection in the Slicers which is answered by your third link.

 

Thanks

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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