Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago
Solved

Show selection on a card

Hello friends!! I have a date segmenter with the option between and what I need is that a card shows the month and year of both dates. If we look at the capture, on the card it should say No...
  • freginier's avatar
    freginier
    4 years ago

    You have to create a measure to do this

    Measure 3 = 
var StartSlicer = MIN('Table'[Column3])
var EndSlicer = MAX('Table'[Column3])
return 
MONTH( StartSlicer ) & "-" & YEAR( StartSlicer ) & " / " & MONTH( EndSlicer ) & "-" & YEAR( EndSlicer )

     You will get something like this : 11-2021 / 1-2022. You can add a switch to convert month number