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 nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
I am attempting to create a treemap that contains information on wells within various stations in a water system. In this case, I am interested in the % specific capacity remaining from the original specific capacity. I did this by creating a calculated column that then groups the data points into 4 common % gradients. I want to put this into a treemap so that each gradient has its own distinct color.
This is my manually drawn mock up in PowerPoint:
The large numbers represent the Station No. which is the "category" in the treemap settings (I was able to achieve this in PowerBI). The small % values in the corners of the squares represent the % of wells within each respective station that are within that % specific capacity gradient (currently in my PowerBI version, the corner values are just the respective % gradient). Each % gradient has its own color as shown in the legend.
This is what I was able to put together in Power BI:
I am not as concerned about placing the % of wells within each station that are in X % specific capacity gradient, as my main priority is figuring out if there is a way to make the treemap coloration based on the field that is placed within the "details". Currently it is colored by category. I am curious as to if anyone knows if this is possible?
Solved! Go to Solution.
Hi @Anonymous
Unfortunately, we don't have a functionality that allows us to combine details with conditional formatting.
There is an idea about this issue please vote for it:
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=22d16ade-8dfe-eb11-b76a-281878deecac
(I voted)
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi @Anonymous
Unfortunately, we don't have a functionality that allows us to combine details with conditional formatting.
There is an idea about this issue please vote for it:
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=22d16ade-8dfe-eb11-b76a-281878deecac
(I voted)
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 23 | |
| 21 | |
| 20 | |
| 18 | |
| 13 |
| User | Count |
|---|---|
| 58 | |
| 51 | |
| 38 | |
| 31 | |
| 26 |