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
Icon for Resolver II rankResolver II
2 years ago

Try this: CLick on the matrix. Click on the V next to fields you want to show

 

mmparvez's avatar
mmparvez
Frequent Visitor
2 years ago

I did:

But the result is same.

  • Data-estDog's avatar
    Data-estDog
    Icon for Resolver II rankResolver 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
        Icon for Resolver II rankResolver II
        2 years ago

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