Adding Dynamic KPI in TreeMap

[Anonymous]

I am using TreeMap and I am trying to differentiate the color based on KPI. Instead of a scale of colors, I would just prefer a bianry color option (two).

Say, if any value above the 5, would appear to be in Red and below that would be Green. I tried following this but my KPIs are dynamic and depend on slicer. Say instead of 5 the KPI would be 7 based on another selection from matrix. I would be able to get the selected value as a measure but I guess the table won't update dynamically based on the selection if I need to follow above tutorial.

[v-frfei-msft]

Hi @Anonymous,

We can format the visual as the picture below. Then we can get the reuslt as you need.

For more details, please check the pbix as attached.

Regards,

Frank

[Anonymous]

But my KPIs are Dynamic. How would you scale based on that?

[v-frfei-msft · Accepted solution]

Hi @Anonymous,

Did you create a measure? Based on my test  the conditional formatting could work well based on a measure.

 

The formula of the measure is:

Measure = SUM(Table1[value])

For more details, please check the pbix as attached.

Regards,

Frank

[v-frfei-msft]

Hi @Anonymous,

Could you please share your sample data or pbix to me? Please upload your file to One Drive and share the link here.

Regards,

Frank

[Anonymous]

So the conditional formatting would work only based on a fixed value but my KPI changes based on slicer.