Forum Discussion
Matrix rows with two headers
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!
2 Replies
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-Forum/ba-p/963216
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/1447523Hi,
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.
