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.
Hi @Anonymous,
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.
Hi @Anonymous,
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.
Helpful resources
FabCon & SQLCon – Barcelona 2026
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
