Custom Gantt Chart Matrix Visual - Category values

[Anonymous]

Hi, I just used a matrix visual for the creation of my gantt chart. However, there are unwanted values in the matrix cell which is supposed to be processed by the conditional formatting. This happens everytime I collide a certain category. 

I want these values not to appear and the cell will be seen as "blank" until I expand the list.

[Anonymous · Accepted solution]

HI @Anonymous,

You can add an if statement to check the current row context level and replace specific level results to blank:

Clever Hierarchy Handling in DAX - SQLBI

Regards,

Xiaoxin Sheng

[amitchandak]

@Anonymous , Need more details.

Option ate create a visual level filter to remove those

Add additional conditions in conditional formatting to make font and background color as white