Looking for an Excel like behavior for a matrix table

[zerosonic]

Hello everybody. I am not sure if I am in the right subforum with my question. I'll try it anyway:
From my input list like:

 I want to create a matrix (similar to the one shown in the picture).

There should be some additional columns, for example, a summation or subtraction over certain attributes (like DAG + ISP or SV - DAG (but only the values with a 9 in the 3rd place of an additional key (in SQL sth. like Group_Key like "__9__").
Furthermore, a total column should be displayed at the end of the matrix.
However, this does not work in my example, because I put the key figures on the rows using the "Show on rows" function.

Does anyone have an idea how I can create the yellow highlighted columns and rows in my matrix? Is what I have in mind even possible? Alternatively, I appreciate any suggestions that helps me to solve the problem. 

[Anonymous · Accepted solution]

Hi @zerosonic,

I'd like to suggest you enable conditional formatting based on expressions to set the fields ' background color' to highlight specific fields. For detailed information about conditional formatting, you can refer to the below document:

Conditional table formatting in Power BI Desktop - Power BI | Microsoft Docs

BTW, if you are confused about the coding formula, please share some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng