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:
var month = SELECTEDVALUE(Dates[OrderMonthName])
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?
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.
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.
I already found it, adding more options to the Concatenatex function
Thank you very much for everything.
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?
@Syndicate_Admin , try like
Concatenatex(Dates, Dates[OrderMonthName], ", ")
Concatenatex(values(Dates[OrderMonthName]), Dates[OrderMonthName], ",")
Find out more about the May 2023 update.
Share your Data Story with the Community in the Data Stories Gallery.