Matrix rows with two headers

[Navemba]

Hi,

I have a table similar to the one bellow

And I wanted to create a matrix similar to this one

Basically, the takeoff and landing excluding the (blanks) and the "-1", but when I apply the filter to one it affects the other as it should when you filter some column.

I tried a few things but wasn't able to achieve this result. I keep getting the landing combined with the takeoff or vice-versa.

I also thouht of creating a new column where I would merge the two basically, like 'landing 12', 'takeoff 37', etc. This way I think I would be able to represent the data like this, but I don't like the idea of creating a merging column for this and also it doesn't work in cases when you have a takeoff and a landing track.

Is there any way of doing this?

Thanks in advance!

[Ashish_Mathur]

Hi,

In the Query Editor, right click on the first column and select "Unpivot Other Columns".  To the matrix visual, drag Attribute and Value to the Row labels and Hour to the Column labels.  Write this measure

Count = countrows(Data)

Hope this helps.

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...