Forum Discussion
KPI Bowler Chart
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.
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
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=ygUsaW1wb3J0IGN1c3RvbW4gaWNvbnMgYXMganNvbiBmaWxlIGluIHBvd2VyYmk%3D)
2 Replies
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
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=ygUsaW1wb3J0IGN1c3RvbW4gaWNvbnMgYXMganNvbiBmaWxlIGluIHBvd2VyYmk%3D)