cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
blackbranded
Helper I
Helper I

Hide text in Subtotal in Matrix

blackbranded_0-1673937392253.png

Is there any way to hide the text fields in the subtotal, such as the type, pillar, start date, end date, project status, and assignee, which are currently visible but not necessary to display? I just need to display the numbers.

2 REPLIES 2
TomasAndersson
Solution Sage
Solution Sage

Hi!
ISINSCOPE() might also be a function you can use to filter out values on certain levels: ISINSCOPE – DAX Guide

Idrissshatila
Solution Sage
Solution Sage

Hello @blackbranded ,

 

Check if this solution works for you https://community.powerbi.com/t5/Desktop/matrix-visual-hiding-subtotal-value-for-text-column-issue-w...

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

 

Follow me on Linkedin

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors