How to Set a KPI on a Calculated Table

[Shionfox]

Hi,

I got the following data:

(Column 4, And Column 5 are Calcualted Columns)

So, in order to sumarize it , I create a table as following 

  

I wanted to create a  table like the following, by now I don't know how to get this done....

My Final Goal is to get a table/report where  if  the value has met the target, then colour the raw on green else color a shape on green, else if the value  has not met the target, then colour the raw on red or else color a shape on red

Does anyone knows how to set it?

[Anonymous]

HI @Shionfox,

I'd like to suggest you create a calculated column with unichar function to display kpi icon in visual.

Reference link:

DAX UNICHAR Function in Power BI

For formatting backcolor based on value, you can take a look at conditional formatting feature.

Conditional formatting in tables

Regards,

Xiaoxin Sheng