- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @HankScorpio2 , To stop any result returning for a row subtotal, just turning of row subtotal should work:
Turn of the row subtotal:
Here is the output, without row subtotal (Tabular style in matrix Layout):
Compact Layout:
If you want to hide specific row subtotal, then go to spcefic column and set only subtotal text color to match back ground:
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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/

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
10-04-2024 10:01 AM | |||
10-22-2024 04:49 PM | |||
09-16-2024 11:43 AM | |||
12-17-2024 03:58 PM | |||
11-29-2024 09:52 AM |