problem with visual descrepncies

[Anonymous]

Hi,

I have a table which is a summary of 234 rows and 6 cloumns (the left one with Actual header) and another one wich is a matrix with user input numbers(Target header in the right). I have a problem when I filter them using a slicer becuase in the left matrix the empty cells disapears but in the right matrix not! Is it possible to have both reacted the same to the slicer?!

The blank cells in the left matrix automatically show up since there is no data and in the right matrix they show up since they have null value.

Is it possible to create "rows subtotal" in the right matrix which has the numbers entered by the user? (some cells are null or no value in them)

[TeigeGao]

Hi @Anonymous ,

Actually, it should not display the null value in the right visual, have you checked the configuration of both visuals?

By the way, if would be pleasant if you can share the pbix file to us for analysis, it will help us finding what has caused this problem.

Best Regards,

Teige

[Anonymous]

@TeigeGao  Did you note that the right matrix is imported as is from excel? It's not summerized nor pivoted. but the right one is the summary of a matrix of 4 columns and 235 rows! Please reply?

[TeigeGao · Accepted solution]

HI @Anonymous ,

Please try to use the IF(....,BLANK(),) to force the blank area display blank(), it will disappear.

Best Regards,

Teige