Transfer excel text formats such symbols, conditional colors into Power BI matrix

[jeongkim]

Hi all,

How can I maintain these format such symbols, conditional colors,,

when I fetch them to Power BI, the symbols and colors gone as it is only in excel formats,,

fyi, it has 2 types of KPI, one is the higher the better(0<gap=green),

the other ones the lower the better(0>gap=green)

1. So how can I make new colums or measure DAX for this?

and really would like to maintain bracket "( )" to differenciate to parent values as it is a gap value.

2. Or if there's any way capture excel screena and just display it on PBI?

Please help me on this this will be very appreciated 🙂

In excel

In PBI

P.S can we change the color of these arrows? like Green and Red? there's no choice for colors...

[amitchandak]

@jeongkim , you have to format the number,

refer

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings

https://www.sumproduct.com/blog/article/power-bi-tips/power-bi-conditionally-formatting-brackets-wit...

For conditional formatting

How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...