Forum Discussion
dynamic slicer title based on user input value
can i change title of slicer based on user provided input value ( not selection) on a prompt ? example , report should provide prompt to user to enter slicer title and that value will be set as a slicer title when user view report
I don’t think that is currently possible without additional tools, as it would require writeback to the model and real-time access to the entered value. You would likely need either Translytical Task Flows or PowerApps writing back to a database, with the entered value then accessed through DirectQuery. While the input slicer allows arbitrary values to be entered, those values are only used to filter the visuals. I don’t think there is currently a way to directly access the entered value itself.
powerbiexpert22
Currently Power BI does not support where user can type in and that text becomes the slicer value.
The data must come from
1-Data Source.
2- Selection
3-Or parameters.
Workaround:
Create Disconnect Table approach
1-a disconnect table with "Title Selector" Table2-Dynamic DAX measure.
3-Conditional formatting.
This is fully support in Power BI Service as well.
If this helps, ✓ Mark as Kudos | Help Others
4 Replies
Hi powerbiexpert22,
Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to Murtaza_Ghafoor & danextian for sharing valuable insights.
Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.
Thank you for being part of the Microsoft Fabric Community.
I don’t think that is currently possible without additional tools, as it would require writeback to the model and real-time access to the entered value. You would likely need either Translytical Task Flows or PowerApps writing back to a database, with the entered value then accessed through DirectQuery. While the input slicer allows arbitrary values to be entered, those values are only used to filter the visuals. I don’t think there is currently a way to directly access the entered value itself.
powerbiexpert22
Currently Power BI does not support where user can type in and that text becomes the slicer value.
The data must come from
1-Data Source.
2- Selection
3-Or parameters.
Workaround:
Create Disconnect Table approach
1-a disconnect table with "Title Selector" Table2-Dynamic DAX measure.
3-Conditional formatting.
This is fully support in Power BI Service as well.
If this helps, ✓ Mark as Kudos | Help Others
Hello powerbiexpert22,
We hope you're doing well. Could you please confirm whether your issue has been resolved or if you're still facing challenges? Your update will be valuable to the community and may assist others with similar concerns.
Thank you.
