Hi everyone,
I have a powerpivot pivot table and in one column I've got a 3-Icon set to do stoplights for the top 20%, the middle 70% and then the bottom 10% of a particular column. Does anyone know of a way (using conditional formatting or maybe a DAX function) to have it actually say "Top 20%," "Middle 70%," "Bottom 10%." I don't think powerpivot does a percentile function so I couldn't just do an if statement. Conditional formatting does essentially exactly what I need but I want to use something else other than just the stop lights. Thoughts?
I have a powerpivot pivot table and in one column I've got a 3-Icon set to do stoplights for the top 20%, the middle 70% and then the bottom 10% of a particular column. Does anyone know of a way (using conditional formatting or maybe a DAX function) to have it actually say "Top 20%," "Middle 70%," "Bottom 10%." I don't think powerpivot does a percentile function so I couldn't just do an if statement. Conditional formatting does essentially exactly what I need but I want to use something else other than just the stop lights. Thoughts?
