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

vcastello's avatar
vcastello
Resolver III
8 years ago

Hi abap32 

When you say ...

"That seems to be the case here - my original sorting by monthID is replaced magically with an alphabetical order"

means that you selected the 'Order by Column' feature and it does not work? Or that you originally sorted by monthID in the original table?

Vicente

  • abap32's avatar
    abap32
    Frequent Visitor
    8 years ago

    Hi vcastello,

    i have used both ordering options on monthID. However the values that are returned from that LASTNONBLANK function are ordered by name. I cannot find another explanation why i am getting the wrong month name returned ( which only makes sense if the month name is ordered alphabetically).

    • vcastello's avatar
      vcastello
      Resolver III
      8 years ago

      Hi abap32

      Try changing the formula to ...

      dynamic_text_last = "Sum of January until " & MAX(Month_Table[Column_Month_Names])

      • abap32's avatar
        abap32
        Frequent Visitor
        8 years ago

        Hi vcastello,

        didnt work.