topic Re: Conditional formatting color issue for Arrow in Martix table visual for Totals in Report Server

Conditional formatting color issue for Arrow in Martix table visual for Totals

RavinderSunkara — Mon, 23 Sep 2019 07:12:50 GMT

Hi Team,

We are able to do conditional formatting to the Trend column but not for the totals in Matrix visual. Currently We are using Power BI report server May 2019 release.

Request you to provide any suggestion for this issue.

Re: Conditional formatting color issue for Arrow in Martix table visual for Totals

MaxNovak — Thu, 26 Sep 2019 07:41:58 GMT

Hi,

My opinion is that the color of the KPI in the total can't be changed, because it isn't a row set, its a Total.

Usually, in these situations, you can turn off the KPI for the total, that way you won't raise questions by the users.

KPI = IF(HASNOVALUE(CATEGORY),KPI, BLANK())