Forum Discussion

DavidB023's avatar
DavidB023
Icon for Helper III rankHelper 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

DavidB023's avatar
DavidB023
Icon for Helper III rankHelper 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.

prateekraina's avatar
prateekraina
Icon for Memorable Member rankMemorable Member
8 years ago

Hi DavidB023,

What is the data type of this column?

Prateek Raina

  • DavidB023's avatar
    DavidB023
    Icon for Helper III rankHelper III
    8 years ago

    prateekraina


    It is decimal number and I turn them in purcent.

    • prateekraina's avatar
      prateekraina
      Icon for Memorable Member rankMemorable Member
      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

      • DavidB023's avatar
        DavidB023
        Icon for Helper III rankHelper III
        8 years ago

        prateekraina,

         

        Thanks for your answer, it worked easily with that after I put an advanced filter on page "is not blank"

         

        Best regards