Matrix visual with different formats and YoY conditional formatting icons

Hi sheepworrier ,

Based on the information you provided, you can follow these steps:

1. In order to format the rows differently in the same Matrix visual object, using calculation groups is really a sensible approach. It allows you to dynamically change the format of the metrics based on the context of the selected calculation item.

By improving the formatting through calculation groups, you have already made progress in this area. To refine this further, make sure that the Calculation Group item for the Percentage metric and the Response Count metric define appropriate format strings.
See the official documentation for more details:

Create calculation groups in Power BI (preview) - Power BI | Microsoft Learn

2. For conditional formats with arrow icons to indicate significant year-over-year changes, the conditional format can be applied directly to Matrix visual objects. Since the second metric with the arrow icon did not produce the expected results, let's consider another approach.
Instead of trying to process the arrow icons by calculating groups, you can apply the conditional format directly to the Matrix visual object. This involves setting up rules for the icons based on your calculated year-over-year change metric values.

To apply conditional formatting using icons, do the following:

Select the Matrix visual object.
In the Visual Effects pane, find the metric to which you want to apply the icon.
Click the drop-down arrow next to the metric and select Conditional Format.
Select Icons and set the rule to display different icons based on the YoY value.
For more information, visit:

Apply conditional table formatting in Power BI - Power BI | Microsoft Learn

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.