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:
drive.google.com/drive/folder...

[@leookechukwu2013]

best video ive watched in months thanks im subscribing immediately

[@sailing_life_]

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

[@thedataanalysttraininghub]

Happy to help

[@vaibhavsaxena2685]

Thanks a Lot!!

[@thedataanalysttraininghub]

You're welcome!

[@mrsberennn]

Thanks for sharing!! This helped me a lot.

[@thedataanalysttraininghub]

Glad it helped!

[@economicseschool]

Thanks for sharing this video. It is very useful.

[@thedataanalysttraininghub]

Glad it was helpful!

[@hiteshjoshi3148]

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

[@thedataanalysttraininghub]

Glad to hear that

[@mohdsareef9254]

Thanks Bro

[@thedataanalysttraininghub]

Welcome

[@Somaaliman]

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

[@thedataanalysttraininghub]

Thank you for your feedback, glad it was helpful. I have added a download link to the video description.

[@sudeepsaxena8023]

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 :)

[@thedataanalysttraininghub]

Thanks for watching