How to sort Power BI matrix created with calculation groups

Рет қаралды 6,854

3 жыл бұрын

After showing the workaround to implement conditional formatting, this video shows how to implement sorting in the Power BI matrix visual when working with calculation groups.
You can find the article on this topic at the following link:
exceed.hr/blog/sorting-in-mat...
Check out our Power Query fundamentals course!
exceed.hr/en/academy/powerque...
#powerquery #powerbi #etltools #data #dataanalysis

Пікірлер: 11

@davidedelman6300 Жыл бұрын

My new "go-to" guy for Calculation Groups. This video needs to be pinned somewhere on the Power BI Community Forums! Thanks so much!

@AnalyticswithProfessor 4 ай бұрын

Thanks

@alisahib8593 3 жыл бұрын

You are awesome man👍👍. Thanks for making that kind of videos. God bless you

@gregoryoliveira8358 11 ай бұрын

Thanks a lot for sharing this with us!

@annelieshulsmans687 2 жыл бұрын

Awesome! Exactly what I needed!! (and very well explained)

@jvorza 9 ай бұрын

Excelent content and very well explained. Thanks for your contributions!

@Andres_El_Paisa 2 жыл бұрын

Geniuos!

@kristianjohannesen3768 2 жыл бұрын

What about the use case where you want to have an easy option to toggle between Sorting between the column values, and total values. How would you achieve that?

@willy3107212 2 жыл бұрын

Method is great! If I always want to sort by the same column (without needing to select a filter) what could I change in the tabular editor?

@ExceedLearning 2 жыл бұрын

Thank you! The easiest way to always sort by a single column is to add the Sorting CG column directly to a visual, then on the filter pane select the wanted sort type... if you do not want to add additional CG, then you have to incorporate its logic to all items in time intelligence CG.