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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Artefact
Helper II
Helper II

Column name not visible in pivot table

Hi,

 

Why isn't the table name not visible when used as a column in a pivot table? It's visible when I use the table as a row.
Only when a insert a second table in the column field it becomes visible (but the second table in the hierarchy is still not visible)

1 ACCEPTED SOLUTION

Hi @Artefact ,

If I understand your scenario correctly that the pivot table you mentioed is matrix in Power BI?

If it is, actually, this is the default behaviour for matrix in Power BI.

For reference, you could have a good look at this document about matrix to learn how to use it.

Best  Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @Artefact ,

I still have a little confused about your scenario.

If it is convenient, could you share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

Best Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi,

 

In the first (left) scenario, the row name and the value name are visible as headers in the pivot table. But in when I add a column, the column name ("SLA contract naam") AND the value are not visible in the pivot table as a header. Why is this?

Knipsel 2.PNG6.PNG

Hi @Artefact ,

If I understand your scenario correctly that the pivot table you mentioed is matrix in Power BI?

If it is, actually, this is the default behaviour for matrix in Power BI.

For reference, you could have a good look at this document about matrix to learn how to use it.

Best  Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.