Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Philippfk
Frequent Visitor

Hide one part of splitted column

Hi all,

 

I got the following matrix structure:

Philippfk_1-1716456513268.png

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:

Philippfk_2-1716456839482.png

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!

1 REPLY 1
v-jialongy-msft
Community Support
Community Support

Hi @Philippfk 

 

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.

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.