Dynamic Title based on Two Slicer Options

[syeena]

Let's say I have two slicer options, first one is Year (2022,2023,2024) and second slicer is Gender (Female, Male). When I selected 2022 for instance, I would like the dynamic title to be diplayed as "Number of Students in 2022", then when I unselect the 2022, it will display  "Total Number of Students". Then I proceed selecting only Female, the title would be "Number of Female Students". Lastly when I select BOTH for example Year 2024 and Gender Male, it will display "Number of Male Students in 2024". How to do this? I already have for the year as below:

var year = SELECTEDVALUE(Student[Date].[Year])

return IF(ISFILTERED(Student[Date].[Year]), IF(HASONEVALUE(Student[Date].[Year]), "Number of Students in " & year, "Total Number of Students"), "Total Number of Students")

[Irwan · Accepted solution]

hello @syeena 

i assumed this is a title of bar chart, line chart, or any other chart.

1. create a new measure to define all your need.

TestMeasure = 
var _Gender = SELECTEDVALUE('Gender'[Gender])
var _Year = SELECTEDVALUE('Year'[Year])
Return
IF(
    HASONEVALUE('Gender'[Gender])&&HASONEVALUE('Year'[Year]),
    CONCATENATE(CONCATENATE("Number of student ",_Gender),CONCATENATE(" ",_Year)),
IF(
    HASONEVALUE('Gender'[Gender]),
    CONCATENATE("Number of ",CONCATENATE(_Gender," student")),
IF(
    HASONEVALUE('Year'[Year]),
    CONCATENATE("Number of student in",CONCATENATE(" ",_Year))
)))

2. in your title option, go to conditional formating.

3. assign the measure to title

here are the results: 

- year only

- gender only

- both

Hope this will help.

Thank you.

[Irwan · Accepted solution]

hello @syeena 

i assumed this is a title of bar chart, line chart, or any other chart.

1. create a new measure to define all your need.

TestMeasure = 
var _Gender = SELECTEDVALUE('Gender'[Gender])
var _Year = SELECTEDVALUE('Year'[Year])
Return
IF(
    HASONEVALUE('Gender'[Gender])&&HASONEVALUE('Year'[Year]),
    CONCATENATE(CONCATENATE("Number of student ",_Gender),CONCATENATE(" ",_Year)),
IF(
    HASONEVALUE('Gender'[Gender]),
    CONCATENATE("Number of ",CONCATENATE(_Gender," student")),
IF(
    HASONEVALUE('Year'[Year]),
    CONCATENATE("Number of student in",CONCATENATE(" ",_Year))
)))

2. in your title option, go to conditional formating.

3. assign the measure to title

here are the results: 

- year only

- gender only

- both

Hope this will help.

Thank you.

[syeena]

It works! Thank you so much @Irwan , very helpful one.

[Irwan]

hello @syeena 

glad to be a help.

Thank you.

[syeena]

One more question actually, what if nothing is selected, neither the Gender nor the Year and I would like it to dislpay "Total Number of Students"?

[Irwan · Accepted solution]

hello @syeena 

you can add another statement in that DAX.

TestMeasure = 
var _Gender = SELECTEDVALUE('Gender'[Gender])
var _Year = SELECTEDVALUE('Year'[Year])
Return
IF(
    HASONEVALUE('Gender'[Gender])&&HASONEVALUE('Year'[Year]),
    CONCATENATE(CONCATENATE("Number of student ",_Gender),CONCATENATE(" ",_Year)),
IF(
    HASONEVALUE('Gender'[Gender]),
    CONCATENATE("Number of ",CONCATENATE(_Gender," student")),
IF(
    HASONEVALUE('Year'[Year]),
    CONCATENATE("Number of student in",CONCATENATE(" ",_Year)),
    "Total Number of Student"
)))

Hope this will help.

Thank you.

[syeena]

Done. Thank you so much!