Trick to Turn-Off Concatenation On X-axis in Power BI 

Thank you for this! I have one report that just wasn't formatting correctly and I couldn't figure out why. Turns out it has an imported theme where the Sort By option was different. I had no idea ever was going on, but this clears it up.

Wow, before seeing your video I had some luck going all the way down the hierarchy and then turning off concatenation, it worked on some visuals, then not on others. I tried your trick and now it works every time! Thanks for making!

thank you so much, in other videos or posts, people don't explain it completely, here I found the answer and it works. thank you again and have a nice day.

Very useful trick Sandeep. Thanks for sharing. Took me 2 years to discover this and stick with me as I knew the button was there but it was not working. I always went back to other reports where it worked, checked the settings … and couldn’t do it 🤬 …. then, after a while I found the Sort By also by mistake 😜

You are a life saver! This was what I've been looking for!

Thank you for this! Just made my client happier!

Thank you so much thats was really helpful I spend a lot of time trying to find a solution for that problem 👏🏻

Thank you very much. I always felt lucky when I managed to make it work

Thank you! That is exactly what I needed for my visuals!! You are the best!

Thank you sir! That is really helpful.

Amazing, Thanks for sharing Sandeep..

Superb... You saved my life

I had the exact same proboem! Immense. Thank you!

This worked. Thanks a lot

Thanks. It is very useful.

Thanks mad! This is what I exactly was looking for :)

Brilliant 👏 thank you so much

Thank you sir, very helpful!

thanks for trick! how did you change the colour of bars in different subcategories?

Thank you! This was driving me mad.

Excellent, thanks for sharing

Thanks man.

I have learnt something new .

Awesome 👍

Muchísimas gracias

Thank you very much!!!

I was wondering, can we do the same with the groups/hierarchies into the Y-axis in a bar chart instead?

How did you change data color in that visual as per category

Good..

Can I again sort by value as well ?

why does your power bi look different from power bi we downloaded on microsoft store

One of the stupidity thing about powerbi. Can't they fix this already😕