Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
i created a matrix that shows for each laundry : total orders, revenue, arrow indicator trend per month
in the rows i have :
-Laundry Name
-MonthYear
and in the values i have :
-successful orders
-orders arrow indicator
-total bill amount
-bill arrow indicator
im getting subtotals for all the values i have but i want the subtotal to be hidden/removed for the arrow indicator only.
i used the function (hasonevalue) which has worked but one issue is that if a laundry has a value for one month , the subtotal for arrow indicator will be shown.
example :
how can i remove the subtotal for the arrow indicator value only , even if it has one value ?
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 19 | |
| 10 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 34 | |
| 32 | |
| 20 | |
| 12 | |
| 11 |