This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
Hello
I have the following month segmentation
What I want is to create a measure where the filter selection is written. The filter is multiple so I can choose more than a month, that's where the problem comes.
I have the following:
ResumenFiltros =
var month = SELECTEDVALUE(Dates[OrderMonthName])
RETURN
COMBINEVALUES(" ; " My: ",my)
If there is only one selection there is no problem, but if there is more than one I get nothing.
Is there a way to show if there is more than one selection?
Thank you.
I've found a clue but I don't know why he does this.
The culmna is ordered by the field month, (numerical field from 1 to 12) but in the view it appears already disordered
The measure I mentioned before does the same, orders exactly the same.
Hello @Syndicate_Admin
I have a problem, it doesn't order me correctly if I select every month
In principle I have ordered that field according to the Month field of the dates table, it should go well, in fact in the filter if it is ordered correctly.
Thank you.
I already found it, adding more options to the Concatenatex function
CONCATENATEX(
Thank you very much for everything.
Best regards
It works perfectly @Syndicate_Admin thank you very much.
There is only one detail to see if it can be done, as you can see in the capture, I get messy months. Is there a way to order?
Thank you.
@Syndicate_Admin , try like
Concatenatex(Dates, Dates[OrderMonthName], ", ")
or
Concatenatex(values(Dates[OrderMonthName]), Dates[OrderMonthName], ",")
Check out the May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 31 | |
| 26 | |
| 23 | |
| 22 | |
| 15 |
| User | Count |
|---|---|
| 63 | |
| 45 | |
| 28 | |
| 24 | |
| 22 |