Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

condensing slicer-driven dynamic titles

Hi

 

I'm trying to set up a dynamic page title based on a slicer selection for quarterly and annual reporting. While I can get the title working to my satisfaction using Chris Webb's tutorial,  I'd like to know if it's currently possible to go a little further. 

 

At the moment, my titles read (for example) Q2, Q3, Q4 2023 - is there a way to abridge/summarise/condense, so that the title reads something like Q2-Q4 2023? 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

    Please try this way:
    Here is my sample data:

    I use this DAX to create a measure:

    Title = 
VAR _min = MIN('Table'[Quarter])
VAR _max = MAX('Table'[Quarter])
VAR _year = MAX('Table'[Year])
RETURN
_min & " - " & _max & " " & _year

    And put this measure into Title:



    The final output is as below:

    This is just an example. The details will have to be modified according to your actual data structure.

    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

    Please try this way:
    Here is my sample data:

    I use this DAX to create a measure:

    Title = 
VAR _min = MIN('Table'[Quarter])
VAR _max = MAX('Table'[Quarter])
VAR _year = MAX('Table'[Year])
RETURN
_min & " - " & _max & " " & _year

    And put this measure into Title:



    The final output is as below:

    This is just an example. The details will have to be modified according to your actual data structure.

    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.