Forum Discussion

ECE's avatar
ECE
Icon for Advocate II rankAdvocate II
8 years ago
Solved

Using Measure as a Visual level filter

Hi,   I have a table where I would like to apply a dynamic date filter, in the form of a measure, as a Visual level filter. The table contains data from two different sources, both containing a "C...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    Hi ECE

    As tested, when the values to be show are the same, the filter using measure doesn’t work.

    But, when the values are different, it works.

    A workaround is to modify the previous formula to the following one

    TestFilter1 = if(MAX([Calendar Day])>NOW()-28,"Show")

     

     

    Best Regards

    Maggie

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi ECE

I make a test as you discrebed.

As far as I known,Measure "TestFilter" uses MAX([Calendar Day]) to define a row content, so if there is no "Calendar Day" column in the table, it can't work as before.

 

Best Regards

Maggie

ECE's avatar
ECE
Icon for Advocate II rankAdvocate II
8 years ago

Thanks for your reply.

That was also what I got to.

 

However, I was looking for a way to use a measure to filter data in the same way as a standard slicer can filter data. A slicer can filter on fx Calendar day, even if Calendar day is not present in the table.

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Hi ECE

    As tested, when the values to be show are the same, the filter using measure doesn’t work.

    But, when the values are different, it works.

    A workaround is to modify the previous formula to the following one

    TestFilter1 = if(MAX([Calendar Day])>NOW()-28,"Show")

     

     

    Best Regards

    Maggie

    • ECE's avatar
      ECE
      Icon for Advocate II rankAdvocate II
      8 years ago

      Hi Maggie,

       

      Thank you very much for your help - that did the trick :)

    • ECE's avatar
      ECE
      Icon for Advocate II rankAdvocate II
      8 years ago

      Hi again,

       

      I am pretty sure you solution actually solved my problem for a while.

      However, now the problem is back - data is not being filtered.. That means, at least not in Power BI Desktop, but it still works in Power BI online, as long as I am not in edit mode... I'am confused..

       

      Is there supposed to be a difference between desktop and online version ?

       

      Is there any other way, I can use a meassure to filter data in a visual, in the same way a slicer filters data?

       

      Hope you can help,

      Best regards,

      Espen

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

       I have very simlar problem: I cannot remove the visual level filters. - now i have set to the one value. 

      Can you advise how to remove it?

      thank you