Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Impactful Individual
2 years ago
Solved

selected values in title

how to show selected reqions in title as shown below in power bi?

 

Tableau:

 

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi powerbiexpert22 ,

     

    Thanks vicky_  for the quick reply and solution. This solution works for single-select slicers, and I'd like to add a slicer multi-select case:

     

    We can create a title measure.

    Title = CONCATENATEX(ALLSELECTED('Table'[Region]),[Region],"&")

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

     

3 Replies

  • vicky_'s avatar
    vicky_
    Super User
    2 years ago

    You need to create a measure to grab the selected value(s) of the slicer. So something like:
    Chart Title = SELECTEDVALUE(Table[Region])

    Then you can use the fx button next in the title formatting options to dynamically change the title.

    • Nfuentes86's avatar
      Nfuentes86
      Helper I
      1 year ago

       

       

      Hi, how can i make my title page change based on my discipline name selection? Help please.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi powerbiexpert22 ,

     

    Thanks vicky_  for the quick reply and solution. This solution works for single-select slicers, and I'd like to add a slicer multi-select case:

     

    We can create a title measure.

    Title = CONCATENATEX(ALLSELECTED('Table'[Region]),[Region],"&")

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.