I have a table with 1,000+ lines, where some months an individual line may have no figure for CY, BUD & LY (in this case I have written the below DAX to “hide” the row);
Actuals && PeriodTableMTD, if([CY MTD.] = 0, BLANK(),[CY MTD.]). etc.
But this then looks strange if there is data in one of the columns (i.e. bud and blanks in the other), as seen below:
Is there a DAX whereby if there is a number in one of the columns, it shows as “0” in the other columns? While still making it blank (and hiding the entire row is all are blank/0?