cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
josipinho
Helper II
Helper II

Matrix sort by value and dimension default

Hello,

 

I have a default order in which my dimension atribute has to be displayed, but I want to order them by total of values. 

To make it easier to understand heres a screenshot of how things look:

 

 

sort_sc.png

 

 

I want the name of countries (ZEM_DZS) to be sorted by totals of maska_prihod, but I want to keep the default order of my age groups (GDG_NAZIV), so from 0-7, 7-14....84-94 should always be displayed in that order.

 

Any ideas how to acomplish this ? Preferably with DAX only, but if necesarry new collumns are fine aswell...

 

 

1 ACCEPTED SOLUTION
v-haibl-msft
Microsoft
Microsoft

@josipinho

 

In your scenario, you need to create a measure and put it in the Matrix visual. Then you can sort it ascending as following screenshot.

 

Matrix sort by value and dimension default_1.jpg

 

Best Regards,
Herbert

View solution in original post

2 REPLIES 2
v-haibl-msft
Microsoft
Microsoft

@josipinho

 

In your scenario, you need to create a measure and put it in the Matrix visual. Then you can sort it ascending as following screenshot.

 

Matrix sort by value and dimension default_1.jpg

 

Best Regards,
Herbert

View solution in original post

worked like a charm ! Can't belive i didnt think of it :S Thank you ! 🙂

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.