Forum Discussion
KPi image inside Matrix table
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
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:
List of Unicode Symbols:
https://www.vertex42.com/ExcelTips/unicode-symbols.html
Regards,
Daniel He
5 Replies
There are lots of different ways of doing this. Here are a couple.
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
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:
List of Unicode Symbols:
https://www.vertex42.com/ExcelTips/unicode-symbols.html
Regards,
Daniel He
