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

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 :)