Forum Discussion
Finding a progression visual
Hi, I'm new to PowerBI and am having trouble finding the right visual to use. I want something that tracks company progression for indpendent steps. I want the a grid-like structure with Compan...
Anonymous you can create a measure for color based on Status
KPI Color = VAR __status = MAX( Table[Status] ) RETURN SWITCH( __status, "Complete", "Green", "InProgress", "Yellow" "Incomplete", "Red" )
In format by drop down select Field Value and select KPI Color measure whcih we created in above step.
Anonymous you can create a measure for color based on Status
KPI Color = VAR __status = MAX( Table[Status] ) RETURN SWITCH( __status, "Complete", "Green", "InProgress", "Yellow" "Incomplete", "Red" )
In format by drop down select Field Value and select KPI Color measure whcih we created in above step.
Works perfectly. Thanks for the timely reponses! parry2k