Forum Discussion

JLarkin's avatar
JLarkin
Frequent Visitor
3 years ago
Solved

Dynamic Title Switcher

Hi all,    I was hoping to get help with a dynamic title of month and year, like so:  This is currently made using the following two formulae:  Title - Selection = CONCATENATEX(     VAL...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi JLarkin 
    Please try

    Title - Selection =
CONCATENATEX (
    VALUES ( DATE_DIM[MNTH_NAME] ),
    DATE_DIM[MNTH_NAME],
    " & ",
    CALCULATE ( MAX ( DATE_DIM[MNTH_NUMBER] ) ), ASC
)

     

    Title =
IF (
    COUNTROWS ( VALUES ( 'DATE_DIM'[MNTH_NAME] ) ) = 3
        && COUNTROWS ( VALUES ( 'DATE_DIM'[QTR] ) ) = 1,
    MAX ( 'DATE_DIM'[QTR] ),
    [Title - Selection]
) & " "
    & SELECTEDVALUE ( 'DATE_DIM'[YR_NBR] ) & " - Total Sales Bookings"

     

     

ShahabHoghooghi's avatar
ShahabHoghooghi
Frequent Visitor
3 years ago

No, If you have a look at the variable I defined, I used lookup value, then for example it lookup when the month name is March, then it gives you the month number column for that specefic selection, which is 3. It means that, this code will be sorted based on Month Number (numerical) not Month Name and will not be alphabetical.

The second concat measure you created is fine. you just need to change the first one and use month number for sorting instead of month name.

Hope it works for you.

JLarkin's avatar
JLarkin
Frequent Visitor
3 years ago

Hi ShahabHoghooghi. 
The textbox is using the [Title - Selection] variable you defined, and it still displays as Feb & Mar & Jan, instead of Jan & Feb & Mar.