Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
lherbert501
Helper V
Helper V

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 %"
1 ACCEPTED SOLUTION
mlsx4
Super User
Super User

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)

 

View solution in original post

2 REPLIES 2
mlsx4
Super User
Super User

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)

 

Thanks @mlsx4 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.