Forum Discussion
Helper IDynamic matrix with categories/subcategories
Helper IThank you 123abc
I created these measures and adding them to the matrix shows the below which is correct. Now I want to filter "ShowCategory1" so it only shows where Subtotal says 1. But if I filter now then nothing shows up since the filter looks at each invidual row for ShowCategory1 and not on the orange subtotals.
So if a orange row for subtotal says 1 it should be visible, if it says 0 it should not show in the matrix.
Community ChampionFollow these steps:
Make sure you have the "ShowCategory1" measure and the matrix visual set up as previously described.
Select the matrix visual on your report.
Go to the "Format" tab in the right-hand pane to access the formatting options.
Expand the "Conditional formatting" section.
Click on "Background color."
Choose "Color scale" from the dropdown menu.
In the "Minimum color" and "Maximum color" sections, select the same color (e.g., white or the background color of your report) to effectively hide the Category1 rows where Subtotal equals 0. This will make them blend into the background.
Adjust the color scale settings as needed for your specific design preferences.
Now, the Category1 rows where the Subtotal value equals 1 will have a visible background, while the Category1 rows where the Subtotal value equals 0 will effectively be hidden as they will blend into the background.
This approach allows you to visually filter out Category1 rows with Subtotal values of 0 while showing those with Subtotal values of 1.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
In case there is still a problem, please feel free and explain your issue in detail, It will be my pleasure to assist you in any way I can.