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])
)

     

7 Replies

  • 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

     

      • 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.