Filter Date

[DavidB023]

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

[prateekraina]

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]

Hi @prateekraina,

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

[prateekraina]

Hi @DavidB023,

What is the data type of this column?

Prateek Raina

[DavidB023]

@prateekraina


It is decimal number and I turn them in purcent.

[prateekraina · Accepted solution]

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]

@prateekraina,

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

Best regards