Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Sort values in matrix values

Hi, i have one table with 4 columns like machine, country ,city  and status.

pls take a  look at the table:

ABC123SpainMadridBad 
ABC123YokeYoke LeftCritical
ABC123IrelandDublinNot present
ABC123GermanyHamburgNot present
ABC123SpainBarcelonaNot present
ABC123EnglandLondonNot present
ABC123PortugalBragaNot present
ABC123DenmarkCopenhagenNot present
ABC123SpainSevillaOK
ABC123ItalyRomeOK
ABC123ItalyMilanOK
ABC123ItalyTurinOK
ABC123PortugalLisbonOK
ABC123GermanyDortmundOK
ABC123PortugalPortoOK
ABC123EstoniaTallinnOK
ABC123YokeYoke RightOK
ABC123ItalyBolognaOK
ABC123GermanyBerlinReally Bad

and i want to create a alert matrix , I have hierarchy columns country/city, the country level:

Yellow_old_5_1-1619081366996.png

 

and as you can on germany, the status is Not present.

City level:

Yellow_old_5_2-1619081413830.png

and i have a alert in Berlin.

I wonder if is possible to change then value in the country level in Germany from Not present to Really Bad, I can only select first or last status in matrix values.

Thanks all help.

 

 

1 ACCEPTED SOLUTION
v-xulin-mstf
Community Support
Community Support

Hi @Anonymous,

 

Is this what you want?

v-xulin-mstf_0-1619515370958.png

Try measure as:

Measure = 
IF(
    MAX('Table'[country])="Germany",
    "Really Bad",
    MAX('Table'[status])
)

The pbix is attached.

 

Best Regards,

Link

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-xulin-mstf
Community Support
Community Support

Hi @Anonymous,

 

Is this what you want?

v-xulin-mstf_0-1619515370958.png

Try measure as:

Measure = 
IF(
    MAX('Table'[country])="Germany",
    "Really Bad",
    MAX('Table'[status])
)

The pbix is attached.

 

Best Regards,

Link

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@Anonymous , we can control column sorting(using sort column). But here you are using status as a measure. And in matrix measure sorting can only happen on grand total

 

refer to my video on column sorting

https://www.youtube.com/watch?v=Qv4wT8_P-AA

Anonymous
Not applicable

Hi , I have edit my post, I dont want to sort the column instead I want to change the values in the highest level of hierchy.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors