Hide Measure and display only subtotal

[Anonymous]

Hi, 

I just started to use Power BI. I am working on resourse utilization report, where the utilization% will be "totalnumber of hours/40" for each week. Now I only want to display this at the end of each month weeknumber. I want to hide all highlighted coloums as its misleading and also color code utilization% toal based on value. Kindly help

[v-jayw-msft · Accepted solution]

Hi @Anonymous ,

Turn off the Auto-size column width and word wrap under Format and drag the field you wanted to hide.

Refer

https://community.powerbi.com/t5/Desktop/hiding-columns-in-Matrix/m-p/544289 

Best Regards,

Jay

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.