Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Jofiel83
Regular Visitor

Slicer selection (Quarter & Month)

Hello, 
I need advice related to seceltion value in slicer. 
My current code looks like: 

Matrix Title =
"Sales for: " &
CONCATENATEX(
    VALUES('Calendar'[Quarter]),
    'Calendar'[Quarter],
    ", "
)
And a resule as this: 
Jofiel83_0-1707154278286.png

I want to add aslo month 

Jofiel83_1-1707154368281.png

And wand information like this: 

Sales for: Q1 (Month: 1,2), Q2 (Month: 4)

Could you please help me write code i DAX 

1 REPLY 1
vicky_
Super User
Super User

Try something like this:

Matrix Title = 
"Sales for: " &
CONCATENATEX(
    VALUES('Calendar'[Quarter]),
    'Calendar'[Quarter] & " (Month: " & CONCATENATEX(CALCULATETABLE('Calendar'), 'Calendar'[Month], ", ") & ") ",
    ", "
)

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.