Forum Discussion
Dynamic Grouping for Tree Map
Hello, I am trying to create a tree map that has dynamic grouping. The measurement is sum of total hours spent on certain categorys. Some categorys would be customer service, auditing, etc. The t...
Of course, here is the calculation I am using is
% hours worked = DIVIDE( [Hours Worked], CALCULATE( [Hours Worked], ALLSELECTED()),0)
Here is the condiontal formatting.
Anonymous -
You actually don't need to use a measure for this - the TreeMap % will do the calculation for you on the straight Hours Worked.
However, as you said, the Treemap locks in the colors and does not update dynamically.
A Hack Work-Around: You can switch a Column Chart, apply your rules and then switch back to a TreeMap.
Please let us know whether that works.
I hope this helps. If it does, please Mark as a solution.
I also appreciate Kudos.
I also appreciate Kudos.