Reply
HankScorpio2
Frequent Visitor
Partially syndicated - Outbound

Hide Row Subtotals on Collapse rows

Hi

 

I have turned off row subtotals. However, If I collapse the field the row subtotals show again. 

Is there a way to stop any result returning for a row subtotal?

 

So in the screenshot I would like to permanently hide the cells highlighted in red. 

 

HankScorpio2_0-1739934343625.png

 

1 ACCEPTED SOLUTION
vicky_
Super User
Super User

Syndicated - Outbound

You can modify your measure to use ISINSCOPE, or ISFILTERED or HASONEVALUE:

Quality Mark = IF(ISINSCOPE(YourTable[Date]), // your measure here, BLANK())

 The particular function might depend on your report specifics - you can read more here: https://www.sqlbi.com/articles/distinguishing-hasonevalue-from-isinscope/

 

View solution in original post

2 REPLIES 2
shafiz_p
Super User
Super User

Syndicated - Outbound

Hi @HankScorpio2 , To stop any result returning for a row subtotal, just turning of row subtotal should work:

 

Turn of the row subtotal:

shafiz_p_1-1739934888426.png

Here is the output, without row subtotal (Tabular style in matrix Layout):

shafiz_p_2-1739934926677.png

 

Compact Layout:

shafiz_p_3-1739935084872.png

 

If you want to hide specific row subtotal, then go to spcefic column and set only subtotal text color to match back ground:

shafiz_p_0-1739935310566.png

 

Finaly, you can programatically turn off any sub total and total. For example:

OrderQty = 
IF(
    HASONEVALUE('Calendar'[Date].[Month]),
    SUM(Sales[OrderQuantity])
)

 

 

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

 

 

Best Regards,

Shahariar Hafiz

vicky_
Super User
Super User

Syndicated - Outbound

You can modify your measure to use ISINSCOPE, or ISFILTERED or HASONEVALUE:

Quality Mark = IF(ISINSCOPE(YourTable[Date]), // your measure here, BLANK())

 The particular function might depend on your report specifics - you can read more here: https://www.sqlbi.com/articles/distinguishing-hasonevalue-from-isinscope/

 

avatar user

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!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 NL Carousel

Fabric Community Update - February 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)