topic Re: Conditional formatting in a table in Custom Visuals Development Discussion

Conditional formatting in a table

irushidm — Fri, 21 Apr 2017 09:05:58 GMT

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.

Type	Sale	Gross Profit	NP
Budget	1000	600	200
Actual	1100 (Green)	590 (Red)	190 (Red)

Re: Conditional formatting in a table

v-viig — Mon, 24 Apr 2017 11:06:08 GMT

Hello @irushidm,

Could you please clarify you used Power BI Table visual or developed your own table custom visual?

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Conditional formatting in a table

irushidm — Mon, 24 Apr 2017 12:07:19 GMT

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.

Thanks

Re: Conditional formatting in a table

v-viig — Wed, 26 Apr 2017 13:25:09 GMT

@irushidm

As far as I know it's impossible unfortunately.

Power BI table and matrix visuals aren't custom ones. Could you please create a question here?

Re: Conditional formatting in a table

ishratkhan — Mon, 08 May 2023 19:34:33 GMT

=if(actual sale>=1000,green,red) than it can be put as field value (Fx)