Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filters are't working after adding a measure

Hi everyone,

 

I added a measure to a page in my report that puts a 0 in for a date that doesn't have any activity.  I needed this so I can forecast future dates without getting the "data is to irregular to forecast" error.  I am realtivley new to Power BI so hopefully I'm just missing a small detail somewhere.  

 

Here is the measure 

Total Amount = IF(ISBLANK(SUM('all'[swipecnt])), 0, SUM('all'[swipecnt]))
 
The main issue is that the visualiztion does not zoom in when I adjusted the BusDate filter to a smaller time period and it flatlines on either side of the time period.
 
Thanks!
 
 

 

 

 
 
 
Need Help

3 Replies

  • jdbuchanan71's avatar
    jdbuchanan71
    Icon for Super User rankSuper User
    6 years ago

    Anonymous 

    Are you using the BusDate as the X axis on the chart?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi jdbuchanan71 ,

      After you asked that question I just had a relization that I was using the wrong date field from the wrong table ğŸ˜… whoops.  I changed the field and now it works.

      Thanks!

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi  Anonymous ,

         

        Glad to hear that you have solved your issue,could you pls make the reply as answered  to close it?

         

        Much appreciated.

         

        Best Regards,
        Kelly
        Did I answer your question? Mark my post as a solution!