The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hello,
I need advice related to seceltion value in slicer.
My current code looks like:
I want to add aslo month
And wand information like this:
Sales for: Q1 (Month: 1,2), Q2 (Month: 4)
Could you please help me write code i DAX
Try something like this:
Matrix Title =
"Sales for: " &
CONCATENATEX(
VALUES('Calendar'[Quarter]),
'Calendar'[Quarter] & " (Month: " & CONCATENATEX(CALCULATETABLE('Calendar'), 'Calendar'[Month], ", ") & ") ",
", "
)
User | Count |
---|---|
14 | |
11 | |
8 | |
6 | |
5 |
User | Count |
---|---|
28 | |
19 | |
14 | |
8 | |
5 |