Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Impactful Individual
3 months ago
Solved

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 sli...
  • danextian's avatar
    3 months ago

    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.

  • Murtaza_Ghafoor's avatar
    3 months ago

    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" Table

    2-Dynamic DAX measure.
    3-Conditional formatting. 

    This is fully support in Power BI Service as well.

    If this helps, ✓ Mark as Kudos | Help Others