Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Power BI Experts,
I have a requirement in what if parameters, where i want to set default values in it when i open the report. If nothing has selected by default it would show the backend data values, if user drag the slider it should show the report data values. Please help. Below example 5555 & 100% data values should automatically select on the slider when the report opens.
Solved! Go to Solution.
you can set default value for this slicer, and if nothing has selected it would return default value, but it can't show value in slicer unless you slider it.
One quick example,
then, I use a card visual to show the return value of Slicer,
e.g.
Could you please mark the solution you find helpful by clicking Accept as Solution. Really appreciate!😃
Best Regards,
Community Support Team _ Tang
If this post helps, please consider Accept it as the solution✔️ to help the other members find it more quickly.
Thank you for your reply. but just as I said before, " it can't show value in slicer unless you slider it.", at least for now.
I suggest you create an idea for it in
https://ideas.powerbi.com/forums/265200-power-bi-ideas to improve the power bi.
Best Regards,
Community Support Team _ Tang
If this post helps, please consider Accept it as the solution✔️ to help the other members find it more quickly.
How are you sharing your report with your users? If you are publishing to PBI Service, then you can open the report in Service, set the slider values to whatever you want, save the report, then when any user opens the report, either from within Service or from a direct link to the report page, it will show the slicers with your saved values.
Please test and let me know if that works for you!
you can set default value for this slicer, and if nothing has selected it would return default value, but it can't show value in slicer unless you slider it.
One quick example,
then, I use a card visual to show the return value of Slicer,
e.g.
Could you please mark the solution you find helpful by clicking Accept as Solution. Really appreciate!😃
Best Regards,
Community Support Team _ Tang
If this post helps, please consider Accept it as the solution✔️ to help the other members find it more quickly.
Hi @v-xiaotang
Thanks a lot for your reply.
Here my requirement is to show the default value "7" in slicer as single value, not in card visual. I am able to show in card visual but how to show in slicer?
Have you solved your problem? If yes, kindly accept it as the solution. Otherwise, please provide more details about your problem so that we can work on it further. Thanks😃
Best Regards,
Community Support Team _ Tang
If this post helps, please consider Accept it as the solution✔️ to help the other members find it more quickly.
Thank you for your reply. but just as I said before, " it can't show value in slicer unless you slider it.", at least for now.
I suggest you create an idea for it in
https://ideas.powerbi.com/forums/265200-power-bi-ideas to improve the power bi.
Best Regards,
Community Support Team _ Tang
If this post helps, please consider Accept it as the solution✔️ to help the other members find it more quickly.
Hi
Please refer this as we have a solution already.
Thanks
Hari
Hi @Hariharan_R ,
Here my requirement is to show the default value in slicer not in any other card visual. Pleae help here, how we can show when open the report default values should display in slicer or user selection input box.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |