TreeMap sorted by Words

[ManuSacchetti]

Hello Comunnity, I have a doubt about the Treemap Filter. I need to sort it by words, so in my case, I need the word "YES" to be in the left and the word "NO" to be in the right:

¿Do you know if this is possible in PBI?

Kind regards.

[Seanan · Accepted solution]

Hi @ManuSacchetti,

This may not be the best way to get the result you are looking for but I tend to find sorting in a treemap can be a bit of a pain. 

But a quick way to get it to show Yes then No would be to transform the yes or no column.

If you replace all of the Yes values with a space in front of it then it will sort the treemap with yes then no.

As I said this is by no means the cleanest option and it may not be a viable option depending on how your report looks but I hope this may be able to help if there are no better alternatives.

[ManuSacchetti]

Thank you Seanan!! It worked 🙂

[amitchandak]

@ManuSacchetti , If you sorting on the text column it should work

[ManuSacchetti]

Hello @amitchandak , thank you for your answer!

What do you mean with text column? I can't find it.