Forum Discussion

DavidB023's avatar
DavidB023
Helper III
8 years ago
Solved

Filter Date

 

Hi everybody !

 

Is there a filter to show on a slicer, only date which have a value associated ?

Here is my table, I don't want date with a 0%...

 

Thanks

Best regards

David

 

Need Help
  • prateekraina's avatar
    prateekraina
    8 years ago

    Hi DavidB023,

     

    Check out this pbix.
    I have tried to replicate your scenario and used a calculated column to achive the result.

    ValueWithoutZero = IF(Table1[Value] = 0,BLANK(),Table1[Value])

     

    Let me know if you face any issues.

     

    Prateek Raina

6 Replies

  • prateekraina's avatar
    prateekraina
    Memorable Member
    8 years ago

    Hi DavidB023,

     

    The column name which you have obfuscated/hidden in the screenshot, from where is that column coming from?

    Is it a measure? or calculated column? or coming directly from your datasource/database?

     

    Prateek Raina

    • DavidB023's avatar
      DavidB023
      Helper III
      8 years ago

      Hi prateekraina,

       

      It comes from my database directly, but I could have similar problem with other column which are calculated column.