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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
BigLo
Helper II
Helper II

Show only totals in a Matrix

Hi,

 

In a matrix visual i want to display the number of workers day-by-day. But only the total of hours and the total of hours of A-Type (not each day but only one time).

Look at my Samples and screenshots.

What i Have...

BigLo_0-1636356748413.png

 


What i Want...(I Hide manually fields for example but if i add a day the fields reappear)

 

BigLo_1-1636356824744.png

 

 

https://1drv.ms/u/s!AnCIbCo-paOMiRUuH1VWjLIxtbGl?e=4S4s04

 

https://1drv.ms/x/s!AnCIbCo-paOMiRYLavL9xkM3mwWe?e=60gu56

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@BigLo , You need a hybrid table, not supported now. You have some workarounds

f you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1...
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...

vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@BigLo , You need a hybrid table, not supported now. You have some workarounds

f you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1...
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...

vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

very frustrating, it seems like a basic option. Thank you for the support! I'll try your solution.
I voted for the idea.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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