Forum Discussion

FGaspar's avatar
FGaspar
Icon for Helper I rankHelper I
6 years ago
Solved

How to hide columns with empty values in a matrix visual.

Hi,   I'm trying to hide empty values in a matrix visual. In the example below I have two measures for each month/year. If both measures are empty in the same month (for all rows), that month shou...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    FGaspar - Yes, you can do this like:

     

    Measure =
  VAR __Calc = <some calculation>
RETURN
  IF(__Calc=0,BLANK(),__Calc)
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

FGaspar , Try to modify measure like

 

new measure = if([measure]=0, blank(), [measure]) // your orginal measure

 and try