Forum Discussion

MikePowerBI's avatar
MikePowerBI
Icon for Helper II rankHelper II
4 years ago
Solved

Date filter does not update x-axis when using date hierarchy

Hi there,   I have a line and clustered column chart and a date filter. The same date column called "Initiation Date" is used for both the date filter and the x-axis of the chart.    When using t...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi MikePowerBI ,

     

    I think this is caused by your INVs Initiated and Avg.INVs per Batch returning 0 values (or not blank) for the filtered out dates section.

    For example, if I use the following measures separately as values for the chart, one will filter the x-axis correctly, while the other will not be filtered because January, February, March... have a return value of 0.

    Note: This situation exists between the date slicer of type "Between" and the date hierarchy.

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

I'm guessing you haven't created a date dimension table and it's automatically building one for you. I'd recommend creating one and using that dimension table for your slicer instead.

 

I recommend reading this for more information:

https://radacad.com/do-you-need-a-date-dimension

  • MikePowerBI's avatar
    MikePowerBI
    Icon for Helper II rankHelper II
    4 years ago

    Hi AlexisOlson thank you for your reponse and for providing the great resource.