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...
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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
Irwan
Super User
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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Done. Thank you so much!