cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Microsoft v-micsh-msft
Microsoft

Re: Setting the Default Value of a Slicer

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

raviteja_prathi
Frequent Visitor

Re: Setting the Default Value of a Slicer

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
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors