Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I would like to use a Red/Amber/Green tracker to track project status over time.
(Shame it wasn't Red/Yellow/Green but thats another story!)
The raw data has a Status field which has the text values of Red, Amber or Green.
To be able to conditionally format an icon into the Status field; upon import of the data a column is added to the table with the values as shown
If Text = Red then the Status Column will be 25%
If Text = Amber then the Status Column will be = 50%
If Text = Green then the Status Column will be = 75%
which enables the following conditional formatting rules to be applied
This works and displays the icons in a matrix as shown:
However, when + sign is used to expand the content of a section the icons appear ok for the expanded section but no longer appear for the remainder of the matrix which displays the numerical values instead of the icons.
Has anyone else seen this behaviour (i.e. losing the conditional formating of the icons upon expansion of a matrix section) and is there a way to display the icons rather than the numbers.
Thanks,
Richard
Solved! Go to Solution.
The conditional format only works for the most granular data.
Refer to this post.
If this helps, mark it as a solution
Kudos are nice too.
Unfortunately, you cannot apply to headers and tows. You can vote for the idea here:
Appreciate your Kudos
Connect with me!
Stay up to date on
Read my blogs on
Did I answer your question? Mark my post as a solution! Proud to be a Super User!
Connect with me!
Stay up to date on
Read my blogs on
Unfortunately, you cannot apply to headers and tows. You can vote for the idea here:
Appreciate your Kudos
Connect with me!
Stay up to date on
Read my blogs on
Did I answer your question? Mark my post as a solution! Proud to be a Super User!
Connect with me!
Stay up to date on
Read my blogs on
The conditional format only works for the most granular data.
Refer to this post.
If this helps, mark it as a solution
Kudos are nice too.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |