powerbireportssrs
I currently have a report produces a matrix, displayed per user group. (1 user group per page, with 35 user groups/pages)
I want to highlight the row in pink in this condition:
=IIf(Fields!CountFailures.Value>=1,"Pink","White")
However, it is not showing any colour. Please help! (I am using PowerBI Report Builder… should be same as SSRS)
It is a bit kludgey, but here's an idea sketch... instead of merging the cells, could you fake it by placing an A in the left cell aligned to the right and a D in the right cell aligned to the left? You could then use expressions to control value, alignment, color, and borders of the two separate cells.
Let me know if you need more details. I think this would give you the visual you want. Good luck!
For each data cell of your table (or matrix) you will have to set an expression on the font color (general tab under text box properties):
Now I am making assumptions of what your dataset/columns are called so you will have to translate those appropriately to your report setup.
For the Revenue and Quantity cells within each category the expression will be something similar to:
==IIF(Fields!ToysRevenue.Value <= 0,"Red","Black")
The expression for your Total Revenue and Total Quantity are a bit more lengthy since you have to check each Revenue value for each category, but it should look something like:
==IIF(Fields!ToysRevenue.Value <= 0 Or
Fields!ClothingRevenue.Value <= 0 Or
Fields!FoodRevenue.Value <= 0, "Red","Black")
Best Answer
If you are formatting cells based on group totals and not a row value, you need to use an aggregate and indicate the correct row group scope. In this sample, "UserName" is the name of the row group scope on the Row Groups section of the Grouping pane