04-21-2017 02:05 AM
Hi how can you use conditional formatting to colour the cell where actual positive performance in green and negative performance in red for each indicator against the budget.
|Actual||1100 (Green)||590 (Red)||190 (Red)|
04-24-2017 04:06 AM
04-24-2017 05:07 AM
Hi what i have shown above is something i did on MS word. With the power BI table/matrix visual i am unable to colour status of the actual performance which is depicted in the second row. If its lower than budget the background colour of the cell/font colour should be red and if its above budget background colour of the cell/font colour should be green. I want to be able present data in that format. Is this possible with Power BI? This is similar to the conditional formatting availble in Excel.