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

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. 

    • vcastello's avatar
      vcastello
      Resolver III
      8 years ago

      Hi abap32

      Could you provida a sample .pbix file somewhere to see exactly the data model?

       

      Thanks

       

      Vicente

      • abap32's avatar
        abap32
        Frequent Visitor
        8 years ago

        Thank you for your help vcastello, but i am really not allowed to do this. I will keep fighting the beast alone :)