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!
User | Count |
---|---|
93 | |
87 | |
85 | |
75 | |
49 |
User | Count |
---|---|
164 | |
149 | |
101 | |
73 | |
55 |