Forum Discussion
Table Vs Matrix
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..
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/
1 Reply
- amitchandakSuper User
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/