Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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 November-2021 / January-2022.
Can you do that?
Thanks a lot.
Solved! Go to Solution.
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
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
Thanks a lot!!
@Syndicate_Admin , Check if you can use timeline slicer
https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa104380786?tab=overview
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 59 | |
| 46 | |
| 42 | |
| 23 | |
| 18 |
| User | Count |
|---|---|
| 193 | |
| 123 | |
| 99 | |
| 67 | |
| 49 |