KPi image inside Matrix table

[sajarac]

Hi there, 

Very new here, and probably this question is already resolved but I cannot figure out.

I have my data in a matrix table with a list aof Sales Representatives + 3 columns in the first column sales and ther other 2 count of

I need to show in the first column a green button for sales over $10,000, a red button less than $10,000 and for the other two column green for count over 5 and red for count less than five.

Thanks in advance for any help!

Regards

[Greg_Deckler]

There are lots of different ways of doing this. Here are a couple.

https://community.powerbi.com/t5/Quick-Measures-Gallery/SVG-Multi-Shape-Multi-Color-Indicators/m-p/5...

https://community.powerbi.com/t5/Quick-Measures-Gallery/Simple-SVG-KPI-Power-BI-august-2018-update/m...

https://community.powerbi.com/t5/Community-Blog/Power-BI-Desktop-Custom-Aggregations-Formatting-and-...

[sajarac]

Thank you very much for your prompt reply.

However it seems like is designed for expert user, and I am currently in baby steps.

I know how to apply icons sets in excel and I was hopping to see the same fuctionality here in PBI. So far I have my table with conditional format "Font Chage" i.e if this number is below to 10,000 red, green.

But I would like to add a nice shape

[Anonymous]

hi @sajarac 

I am also taking baby steps.

Curious to know how did you sort this one out?

I have the same need and seem to be facing the same problems as you. and have the same skill level 🙂

Thank you

J

[sajarac]

Hi,

I created a Measure i.e KPI

KPI = UNICHAR(11044)

Then in my table I have added a column "KPI" KPI in my case was rename to "Min 10K Sale"

Now in that column for the conditional format I changed the format by "Rules" based on my taste

Regards,

Sajarac

[v-danhe-msft · Accepted solution]

Hi @sajarac,

Based on my research, you could use the UNICHAR function to show different shape, you could refer below link to set different symbols:

https://community.powerbi.com/t5/Community-Blog/Power-BI-Desktop-DAX-Using-Unicode-Arrows-as-Measure...

List of Unicode Symbols:

https://www.vertex42.com/ExcelTips/unicode-symbols.html

Regards,

Daniel He