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