Forum Discussion
KPI Creation
Hello friends,
Please help on this requirement need to show traffic light indicator at the page level with the help of 2 calculated columns
see the attachmentScenario
Hi RENJITH_R_S ，
Use the issue table as an example, you can create a measure like this and put it in the card visual without setting conditional format for it:
Traffice for issues = VAR _issues = SELECTEDVALUE ( Issues[Issue Flag] ) RETURN IF ( NOT ( ISBLANK ( _issues ) ), SWITCH ( TRUE (), _issues == 0, UNICHAR ( 128994 ), _issues = 1, UNICHAR ( 128993 ), _issues = 2, UNICHAR ( 128308 ) ), UNICHAR ( 9898 ) )Default status:
When select an issue flag:
Risk table is the same as the issue table, just change the parameter in the variable.
Attached a sample file in the below, hope to help you.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
RENJITH_R_S , you can do icon formatting in table or matrix
or
https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
Thanks amitchandak , for the response, I did it your idea in my table, but my requirement is need to show the 3 icons separately on the table at top based on these 2 calc columns
RENJITH_R_S , You might have disply them on three cards .
If needed refer this :https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692
Thanks amitchandak Let me try this
Hi RENJITH_R_S ，
Use the issue table as an example, you can create a measure like this and put it in the card visual without setting conditional format for it:
Traffice for issues = VAR _issues = SELECTEDVALUE ( Issues[Issue Flag] ) RETURN IF ( NOT ( ISBLANK ( _issues ) ), SWITCH ( TRUE (), _issues == 0, UNICHAR ( 128994 ), _issues = 1, UNICHAR ( 128993 ), _issues = 2, UNICHAR ( 128308 ) ), UNICHAR ( 9898 ) )Default status:
When select an issue flag:
Risk table is the same as the issue table, just change the parameter in the variable.
Attached a sample file in the below, hope to help you.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
