Forum Discussion

lherbert501's avatar
lherbert501
Post Prodigy
3 years ago
Solved

Dynamic Title Nothing Selected

Hi,

 

I've got a dynamic title which runs off a slicer which works fine as below.

 

How would I amend this to display something when no filter is selected as currently both options show together on the title?

 

I have it on single select so it's just when nothing is selected, not both.

 

Growth =
  "" &
  CONCATENATEX (
   'Measure','Measure'[Measure Name],
     
        " ,")
    & " Growth YoY %"
Need Help
  • mlsx4's avatar
    mlsx4
    3 years ago

    Have you tried to do something similar to this?:

    Growth =

var result=
  "" &
  CONCATENATEX (
   'Measure','Measure'[Measure Name],
     
        " ,")
    & " Growth YoY %"

return if(selectedvalue[slicerField]="","My title",result)

     

2 Replies

  • mlsx4's avatar
    mlsx4
    Memorable Member
    3 years ago

    Have you tried to do something similar to this?:

    Growth =

var result=
  "" &
  CONCATENATEX (
   'Measure','Measure'[Measure Name],
     
        " ,")
    & " Growth YoY %"

return if(selectedvalue[slicerField]="","My title",result)