Forum Discussion

TimNYC's avatar
TimNYC
Icon for Helper I rankHelper I
6 years ago
Solved

Line Chart Year-Over-Year Filtered by Month and Day / How Do I Apply a DAX Filter to a Chart?

I'm trying to build a line chart that shows year-over-year sales growth and updates dynamically based on the yesterday's date. I want it to look just like in the attched picture, except the X-Axis sh...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Put the measure on the visual filter and use <> 0

TimNYC's avatar
TimNYC
Icon for Helper I rankHelper I
6 years ago

Thank you for your time. I may have explained the issue poorly. I'm not trying to filter the data in the chart, which is probably how my question was interpreted, I'm trying to adjust the X-Axis so that it does not includes dates with no data. I'm going to post a new topic with a better explaination.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Put the measure on the visual filter and use <> 0

  • TimNYC's avatar
    TimNYC
    Icon for Helper I rankHelper I
    6 years ago

    Thank you! That did it. Such a simple solution... I don't know why it didn't occur to me before I posted.