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 includes all dates from 2023 and 2024. I appears that this is automatic as there are no data from January to August 2023. Is there a way to use the date hierarchies but restict to a school year?

 

 

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....

6 Replies

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

    Hi greg_r 

    can you make sure, that when right-clicking on your Date Hierachy field in the x-axis section the option "Show items with no data" is turned off? This should solve the problem.

    • greg_r's avatar
      greg_r
      New Member
      2 years ago

      Yes, it's turned off., 

       

       

    • greg_r's avatar
      greg_r
      New Member
      2 years ago

      And the table that's being used as the x-axis only contains data from 2023-09-01 to 2025-08-31.  

      • timalbers's avatar
        timalbers
        Icon for Skilled Sharer rankSkilled Sharer
        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....