Table Vs Matrix

[kleighton]

Hi,

I seem to be stuck in a bit of a catch22 situation, hopefully someone can assist..

I need to display a visual showing a list of projects and the products inside those projects. I need to show many fields relating to the products which i want to represent by conditional formatting (green icon) or (red icon).

Displaying my visual as a table, this works fine..

However, as you see, 1 sales project can have many sales products and this is not the best way to show the visual

So i change to matrix table

Better, but with the values in the "Rows" section, i cannot do conditional formatting to show the icon instead of the value

So i move them to "Values" section

Now i can perform conditional formatting, but once the fields are moved to "Values", they are forced with an aggregate and i cannot specify "Don't Summarize" so the conditional formatting is not working..

Help..

[amitchandak · Accepted solution]

@kleighton , Not very clear. In matrix, anything in values has to aggregate. And conditional formatting is only on values.

Create an idea or vote for the existing one - https://ideas.powerbi.com/ideas/