Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Dynamic Title based on Two Slicer Options

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")
Need Help
  • Irwan's avatar
    Irwan
    2 years ago

    hello Anonymous 

     

    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's avatar
    Irwan
    2 years ago

    hello Anonymous 

     

    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.

6 Replies

  • Irwan's avatar
    Irwan
    Icon for Super User rankSuper User
    2 years ago

    hello Anonymous 

     

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

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

      • Irwan's avatar
        Irwan
        Icon for Super User rankSuper User
        2 years ago

        hello Anonymous 

         

        glad to be a help.

         

        Thank you.