Forum Discussion

RavinderSunkara's avatar
RavinderSunkara
Icon for Advocate II rankAdvocate II
7 years ago

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

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.

 

1 Reply

  • 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())