March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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], ",")
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
132 | |
90 | |
88 | |
64 | |
58 |
User | Count |
---|---|
203 | |
141 | |
107 | |
73 | |
70 |