KPI Creation

[RENJITH_R_S]

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

[v-yingjl · Accepted solution]

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.

[amitchandak]

@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

[RENJITH_R_S]

Thanks @amitchandak Let me try this

[amitchandak]

@RENJITH_R_S , you can do icon formatting in table or matrix

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting#add-ic...

or

https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/

[RENJITH_R_S]

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