Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Showing Values Less than Date chosen

Hi ,  I have a table in this format    I am trying to choose a date or range (for example when i choose 16-05-2019) the output should be  but if I choose 19-05-19 I will want to see    ...
Interesting Links
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Redsilk - I've tested, and I'm not having issues using measures in filters (vs. slicers), this seems to work fine. We're in the process of moving away from slicers altogether - with the new filter pane experience, filters are much nicer.

 

Can you use a filter instead?

 

Thanks,

Scott

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi sp42, 

 

I just tried it but the filter pane will not accecpt the measure column. I will look further into it, but at them moment we are managing with the fix from the link I sent above

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi redsilk - you should be able to do add a measure filter on the fitler pane - but it needs to be a VISUAL level filter, not page or report level. I think they don't allow filtering measures at the page and report levels because there isn't enough context for figuring out what the metric value should be.

     

    Hope this helps!

    Scott