Sorting Gone WRONG? Resolve Circular Dependencies | Power BI Tutorial for Beginners

This is a common scenario in Power BI: You have a column that calculates age. Your user wants a slicer to filter the data in age groups. When you try to order the slicer correctly, you're hit with a circular dependency error.

In this video I'll show you how to avoid it and create slicers that are ordered correctly.

Want to try it yourself? Download the files here:

[leookechukwu]

best video ive watched in months thanks im subscribing immediately

[scottboyd]

I was trying to sort columns on a matrix visual - same issue. Thank you for the step by step, showing the errors along the way. Very helpful.

[Payal-yy]

It was helpful.. Was facing the same issue.. Thanks for such a detailed video✨

[sailing_life_]

Thanks for going through the different errors and how you resolve them.

[mrsberennn]

Thanks for sharing!! This helped me a lot.

[hiteshjoshi]

Thanks guru it really helped me to sort By month in report view.

[economicseschool]

Thanks for sharing this video. It is very useful.

[sudeepsaxena]

Hi Milan! I tried sorting months and days in chronological order by creating two separate tables and then linking them to the main table using the appropriate columns as shown in the video. But the columns I want to sort using the day_num and month_num values do not pick these two columns. They don't appear in the list of columns under the 'Sort by column' option.

However, when I tried creating the DayNum and MonthNum columns using the UI option of creating a conditional column, the same columns got sorted without giving the circular dependency error (even though the results of UI created and formula created DayNum and MonthNum columns were exactly the same).

Could you please tell us what the issue might be??? Thanks in advance :)

[Somaaliman]

Thanks & that was a good knowledge. Will it be possible to share the data so one can play with it?