The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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], ",")
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
121 | |
86 | |
77 | |
55 | |
48 |
User | Count |
---|---|
136 | |
128 | |
78 | |
64 | |
63 |