Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
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.
Solved! Go to Solution.
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.
Thank you Seanan!! It worked 🙂
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 23 | |
| 22 | |
| 17 | |
| 13 | |
| 13 |
| User | Count |
|---|---|
| 62 | |
| 41 | |
| 39 | |
| 38 | |
| 38 |