Forum Discussion

abap32's avatar
abap32
Frequent Visitor
8 years ago
Solved

Display Slicer value dynamically on card

I have a Month slicer and i want to display the Month name of the selected number ( 8 = August) on a card.       I am using the following measure:  dynamic_text_last = "Sum of January until ...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi abap32,

     

    Based on my test, the formula below should work in your scenario. :smileyhappy:

    dynamic_text_last =
"Sum of January until "
    & FORMAT ( DATE ( 1900, MAX ( Month_Table[Column_Month_Number] ), 1 ), "mmmm" )

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi abap32,

 

Based on my test, the formula below should work in your scenario. :smileyhappy:

dynamic_text_last =
"Sum of January until "
    & FORMAT ( DATE ( 1900, MAX ( Month_Table[Column_Month_Number] ), 1 ), "mmmm" )

 

Regards

abap32's avatar
abap32
Frequent Visitor
8 years ago

v-ljerr-msft Is there a possibility to alter your code in order to display the Month names in German language?

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi abap32,

     

    Try the formula below. It may not be a smart way, but it should work. :smileyhappy:

    dynamic_text_last = 
VAR monthNameInGerman =
    SWITCH (
        MAX ( Month_Table[Column_Month_Number] ),
        1, "der Januar",
        2, "der Februar",
        3, "der März",
        4, "der April",
        5, "der Mai",
        6, "der Juni",
        7, "der Juli",
        8, "der August",
        9, "der September",
        10, "der Oktober",
        11, "der November",
        12, "der Dezember"
    )
RETURN
    "Sum of January until " & monthNameInGerman

    Regards

    • abap32's avatar
      abap32
      Frequent Visitor
      8 years ago

      v-ljerr-msft i cannot thank you enough!