KPI setting with Arrow - trolling forth and back under blue graph

[Chanleakna123]

Hi , I found this on BI sample , may I know how to create the table with red and green KPI with arrow up and down ? 

I’d also like to compare TY VS. LY. On my report 

*How to use graph with filtering by only dragging forth and back as shown with *black trolley under the month blue graph? 

[v-qiuyu-msft]

Hi @Chanleakna123,

You can create a measure or calculated column to concatenate UNICHAR(9650) (up arrow) or UNICHAR(9660) (down arrow), with other calculation which returns actual LY values. You can refer to this blog: https://community.powerbi.com/t5/Community-Blog/Power-BI-Desktop-DAX-Using-Unicode-Arrows-as-Measure...

Best Regards,
Qiuyun Yu 

[Chanleakna123]

@v-qiuyu-msft i read the articles i have done half of it. but i fail to get the color of up and down arrow, do you have any guide of how to fix this ? 
 

[v-qiuyu-msft]

Hi @Chanleakna123,

From the screenshot you shared in your initial post, the arrow color is the same with combined value color. So you can set condition formatting for the font color in the table visual, see: https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#font-color-scales

Best Regards,
Qiuyun Yu