Forum Discussion

rscully's avatar
rscully
Frequent Visitor
6 years ago

Ignore Page time filter for a Trend Visual

I first apologize for any syntax errors when trying to explain my situation.

 

I have a page filter that is set to 'Last 1 Day' which works for the majority of the visuals on my page except for two 60-day line charts that I have on the page.  Instead of displaying the 60 data points, the visual only returns the last 1-day data point as defined by my page filter.  I have tried various techniques (ALL and ALLEXCEPT using the FILTER function) to try and figure out out how to have the line chart ignore the page filter and instead use a defined time period but I don't think I'm even approaching the problem correct way.  The following calculation returns the total value defined by the time range but I actually need the individual data points reflected on the line chart not just one total

 

Days Actual Trend = CALCULATE('CL_Census'[Days Actual],FILTER(ALL('Time'[ApplyDate]),AND('Time'[ApplyDate]>=TODAY()-60,'Time'[ApplyDate]>=TODAY()-1)))

 

Any assistance or guidance you can provide would be greatly appreciated!

 

Need Help

4 Replies

  • v-xuding-msft's avatar
    v-xuding-msft
    Community Support
    6 years ago

    Hi rscully ,

    The visuals will be always filtered when we use "Filter on this page" pane or "Filter on all pages" pane.  You could try to add a slicer to filter the page. Then you can click the slicer to edit interactions and choose no impact on others. More details, you could reference the documents : Change how visuals interact in a Power BI report.  If you need to filter on all pages, you could sync the silcer and follow the steps above.

     

    Best Regards,

    Xue Ding

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.

    • rscully's avatar
      rscully
      Frequent Visitor
      6 years ago

      Xue,

      Thanks for your reply.

       

      I was hoping to use filters instead of slicers due to space limitations on the page.  I guess if we can't figure out a solution using filters I can try to set it up with slicers.

       

      Rich  

      • v-xuding-msft's avatar
        v-xuding-msft
        Community Support
        6 years ago

        Hi rscully ,

        The option of Filter on the page will be always filtering our visuals. You could reference the video to build a slicer panel in your report. It is using bookmarks and group features to implement it. In this way, the slicer is hided in the panel. It won't take up space.  And you could reference this video to understand how to choose filter and slicer.

         

        Hope this will help you.

         

        Best Regards,

        Xue Ding

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.