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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
VijayAntonyM
Helper I
Helper I

Dynamically show the column in Matrix

Team,

 

I need to show the Average column along with Total in Matrix for selected columns 

based on the selected hours, Average will be dynamically calculated in table.

 

Average column should not display for each hours as below, but should display only once along with total.

 

VijayAntonyM_0-1705378091179.png

 

Thanks

M. Vijay Antony

2 REPLIES 2
VijayAntonyM
Helper I
Helper I

Thanks for the idea and support,

Anonymous
Not applicable

Hi @VijayAntonyM 

 

For the requirement "Average column should not display for each hours as below, but should display only once along with total", this is currently not supported in the matrix visual. The number of total columns is always consistent with the number of value fields. 

 

You can vote up the following idea regarding a similar feature requirement:

Hybrid Table - Matrix and Table together

 

Best Regards,
Jing

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors