KPI Bowler Chart

[Anonymous]

Hello Everyone,

I am new to PowerBI (but familiar with Tableau, not sure if that helps). I need to replicate the visuals shown in the image as a dashboard in PowerBI. In raw data, I have Actual, Plan, KPI type in Columns and KPI's as rows. 

The symbols are particularly important and the legend explains the combination of symbols.

I need some guidance to create the visuals.

Any help is appreciated.

Thanks in advance.

[Anonymous · Accepted solution]

HI @Anonymous,

You can take a look at the following blog about how customize the visual to add icons or specific characters:

Tips on displaying icons based on field values in ... - Microsoft Fabric Community

Regards,

Xiaoxin Sheng

[Anonymous · Accepted solution]

HI @Anonymous,

You can take a look at the following blog about how customize the visual to add icons or specific characters:

Tips on displaying icons based on field values in ... - Microsoft Fabric Community

Regards,

Xiaoxin Sheng

[Anonymous · Accepted solution]

Hi Xiaoxin Sheng, Thanks a lot for the reply, yes, I had seen the post, and it was my last resort, since I was wondering whether a default option is there to show two icons at once. For those who find the question relevant, here is the detailed solution.

I added a helper column for which formula is mentioned below.

if [KPI Type] = "Lower the better" and [Actual]<= [Target] then "TARGET MET LOWER"

else if [KPI Type] = "Lower the better" and [Actual]> [Target] then "TARGET NOT MET LOWER"

else if [KPI Type] = "Higher the better" and [Actual]>= [Target] then "TARGET MET HIGHER"

else if [KPI Type] = "Higher the better" and [Actual]< [Target] then "TARGET NOT MET HIGHER"

else if [Actual]=" " then "DNA"

else if [Actual]=BinaryFormat.Null then "DNA"

else ""

The First four conditions in formula are nothing but the same as the four-legend shown in the image above. Now, I saved the image shown in legend as individual image and imported theme as json file.

(link for detailed steps >> https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-july-2019-feature-summary/, easy YouTube tutorials>>>https://www.youtube.com/watch?v=diX_-eZj47k&t=31s&pp=ygUsaW1wb3J0IGN1c3RvbW4gaWNvbnMgYXMganNvbiBmaWx...)