Forum Discussion
problem with visual descrepncies
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 probl...
HI Anonymous ,
Please try to use the IF(....,BLANK(),) to force the blank area display blank(), it will disappear.
Best Regards,
Teige
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
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?
HI Anonymous ,
Please try to use the IF(....,BLANK(),) to force the blank area display blank(), it will disappear.
Best Regards,
Teige