Blog Post

Power BI Community Blog
2 MIN READ

Power BI Desktop: Custom Aggregations, Formatting and Performance Indicators (Part 2)

Dianapo's avatar
Dianapo
Microsoft Employee
8 years ago
This multi-part tutorial blog is geared to help BI Analysts create versatile Scorecards with KPIs as well as to faciliate the business reporting transition from Excel, SSRS or other apps to Power BI ...
Updated 8 years ago
Version 4.0
how to
tips & tricks
Dianapo's avatar
Microsoft Employee
Joined February 01, 2018
View Profile
Power BI Community Blog
On this blog you will find articles, guides and information created by our community members and, from time to time, roundups and community news. If you are interested in becoming a community blog author, send a private message to Natalie_iTalent. An overview of the community blogs can be found here.
Dianapo's avatar
Dianapo
Microsoft Employee
7 years ago

Thanks Anonymous and you can definitely create a column with the kpi color and count the measures and maybe one day I will get around to writing part 3 which addresses these extras.

 

This is the code for the KPIColumn to plug into your chart (which I just quickly wrote but haven't tested)

KPIColumn = IF([Target] = 0, "   Needs Target " & UNICHAR(128211), IF([ActualAgainstTarget] >= 0.95,  " Over 95% of Target " & UNICHAR(128215), IF([ActualAgainstTarget] < 0.75,  "  Below 75% of Target " & UNICHAR(128213), IF([ActualAgainstTarget] > 0.75, " 75% to 95% of Target " & UNICHAR(128210), "   Needs Target " & UNICHAR(128211)))))