Forum Discussion
Post ProdigyKPI setting with Arrow - trolling forth and back under blue graph
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?
3 Replies
v-qiuyu-msftCommunity Support
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-Measures-in-a-Table/ba-p/190725
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
