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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi Everyone,
How to hide column with zero values? Seen couple of forums here and found nothing that works in my case. I even filter on page visual.
My measure on total is:
Appreciated your help on this.
@rbalza , Try like
Totals =
var _1 = [Op Bal Interim Transactions] +
CALCULATE(
[Journal Lines Total] ,
FILTER(
ALLSELECTED( Dates),
Dates[Date] <= MAX( Dates[Date])
)
)
return if(_1= 0, blank(), _1)
not working 😞 Appreciate your help.