Forum Discussion
Custom Gantt Chart Matrix Visual - Category values
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.
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
2 Replies
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
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
