Forum Discussion

greg_r's avatar
greg_r
New Member
2 years ago
Solved

Restrict Date Hierarchy in Chart

I have attendance data for a school board where the year runs from September 2023 to June 2024. I like the drill down feature of date hierarchies however when I apply to the x-axis of a plot it inclu...
Need Help
  • timalbers's avatar
    timalbers
    2 years ago

    Ok greg_r  I will need to have some more information in order to help you. 
    What type of field are you using for the y-axis? Is it a measure or a column? If it is a measure or a calculated column, can you provide the DAX? Maybe the values are not really blank but 0....

greg_r's avatar
greg_r
New Member
2 years ago

It's a measure that was adding 0 (often used in other circumstances where stakeholders want to see the zeros). I removed that part of DAX and it corrected. 

 

Thank you for your time and quick response!

timalbers's avatar
timalbers
Icon for Skilled Sharer rankSkilled Sharer
2 years ago

You're welcome, I am glad it works now.
I would apprechiate it, if you marked my answer as solution, thank you!

Have a nice weekend!