is it possible to show the column as blank at visual level based on some condition

[unnipbi123]

Hello All,

i have a tricky situation here. i have created a below reports for sales rep to check from the seats added, how many seats are touched.

is it possible to show the touched seats as blank if the total seats added in any month/quarter is negative? i dont want to show it as blank at the row level in my data. but only at the visual level, i need to show it as blank based on condition.

Thanks,

[Keith_Fernandes · Accepted solution]

Here is my shot to this-

Data set-

Dax-

Seat count = IF(calculate(SUM(Sheet1[Seats]),Sheet1[Category]="Seats added")<0,IF(SELECTEDVALUE(Sheet1[Category])="Seats added",CALCULATE(sum(Sheet1[Seats]),Sheet1[Category]="Seats added"),BLANK()),sum(Sheet1[Seats]))

Final Matrix

Do mark it as a solution if this solves it.

Cheers

Keith Fernandes