Forum Discussion

mmparvez's avatar
mmparvez
Frequent Visitor
2 years ago
Solved

Slicer doesn't show column with zero value

I have a simple table A matrix with a slicer shows:  But on the 20 January it shows only male:  But i like to see it with "F" column with 0 values. How can i do that?
Need Help
Tips and Tricks
  • Data-estDog's avatar
    Data-estDog
    2 years ago

     

    Just wrap it around the main expression:

    YTD = TOTALYTD(
   IF(ISBLANK(SUM('Sheet1'[Value]),0,SUM(Sheet2[Value]))
  ,'Sheet1'[Date].[Date]
  ,'Sheet1'[Date]<= SELECTEDVALUE(Sheet1[Date])
)

     

Data-estDog's avatar
Data-estDog
Resolver II
2 years ago

Then you have two options. Separate the Sex column into its own dimension:

 

Or fill in the missing entries with Zeros

I split into separate Dimension and it works: 

Matrix Settings:

 

Well.. doesn't show a 0... just blank. 

 

Be sure to mark as solution if this provided the answer. 

mmparvez's avatar
mmparvez
Frequent Visitor
2 years ago

Thanks Data-estDog . But on YTD shows no value for F.

 

YTD = TOTALYTD(SUM('Sheet1'[Value]), 'Sheet1'[Date].[Date], 'Sheet1'[Date]<= SELECTEDVALUE(Sheet1[Date]))

 

 

  • Data-estDog's avatar
    Data-estDog
    Resolver II
    2 years ago

    Fair enough. One more trick. Instead of adding an implicit measure, add and explicit measure and correct for isblank: 

     

    • mmparvez's avatar
      mmparvez
      Frequent Visitor
      2 years ago

      Can you please explain. How can i do it with YTD measure? YTD of 20 January should show the F value 30 not 0.

      • Data-estDog's avatar
        Data-estDog
        Resolver II
        2 years ago

         

        Just wrap it around the main expression:

        YTD = TOTALYTD(
   IF(ISBLANK(SUM('Sheet1'[Value]),0,SUM(Sheet2[Value]))
  ,'Sheet1'[Date].[Date]
  ,'Sheet1'[Date]<= SELECTEDVALUE(Sheet1[Date])
)