Showing results for 
Search instead for 
Did you mean: 
Shionfox Visitor

How to Set a KPI on a Calculated Table



I got the following data:




Data 1.JPG


(Column 4, And Column 5 are Calcualted Columns)


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


Data.JPG  Values.JPG



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


KPI Raw Line.JPGKPI Shape-Icon.JPG


Does anyone knows how to set it?

Community Support Team
Community Support Team

Re: How to Set a KPI on a Calculated Table

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



Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

For learning resources/Release notes, please visit: | |

Helpful resources

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 41 members 1,164 guests
Please welcome our newest community members: