cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Syndicate_Admin
Administrator
Administrator

Measure show multiple segmentation values

Hello

I have the following month segmentation

apenaranda_0-1675343352614.png

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.

6 REPLIES 6
Syndicate_Admin
Administrator
Administrator

Hello @Syndicate_Admin

Can you help me?

Thank you.

Syndicate_Admin
Administrator
Administrator

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

apenaranda_0-1675675909912.png

The measure I mentioned before does the same, orders exactly the same.

Syndicate_Admin
Administrator
Administrator

Hello @Syndicate_Admin

I have a problem, it doesn't order me correctly if I select every month

apenaranda_1-1675413316826.png

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.

Syndicate_Admin
Administrator
Administrator

I already found it, adding more options to the Concatenatex function

CONCATENATEX(

[, [, [, ]]...])

Thank you very much for everything.

Best regards

,
Syndicate_Admin
Administrator
Administrator

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?

apenaranda_0-1675405422970.png

Thank you.

amitchandak
Super User
Super User

@Syndicate_Admin , try like

 

Concatenatex(Dates, Dates[OrderMonthName], ", ")

 

or

 

Concatenatex(values(Dates[OrderMonthName]), Dates[OrderMonthName], ",")



!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors