Hide one part of splitted column

[Anonymous]

Hi all,

I got the following matrix structure:

The matrix is supposed to show the sales histroy by customer from 2020 -2028.

Therefore the columns "FC" and "Plan" are empty from 2020-2023 and there is only data in "abgerechnet" (=german for already booked). In 2024 there is data in "abgerechnet" and "FC" but not in Plan. And from 2025-28 there is only data in "Plan".

The problem now is that there are many empty colums which I can´t hide since I can only hide the full year.

This is how the matrix is structured:

Type is a column from the input data and contains the info if its "FC, Plan or abgerechnet". The values are meassures filtering for the type so I could split the columns in the first point.

Does anyone have an idea how I could solve this problem? I don´t really want to create more than one matrix since it would get pretty confusing.

Thanks in advance for any help!

[Anonymous]

Hi @Anonymous 

Unfortunately, Power BI does not allow hiding parts of a split column. If you don't want to display columns with blank values, you can only create multiple matrices.

Best Regards,

Jayleny

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