Forum Discussion

ddave84's avatar
ddave84
Frequent Visitor
2 years ago

Work Week continuous data vs. categorical Graphing issue

I'm trying to graph data from 2023 to 2024 using the work week in the format YYYYWW.  When the Workweek is continuous I can see 202354-202399 which don't exist.   When I change to categorical the data looks correct but I lose the capability to use my X and Y constant lines that are required for the visualization.  Is there a way to address the issue?  

 

https://www.dropbox.com/scl/fi/1jyzmaaj4xwvd4g4lcdel/Continious_Model.pbix?rlkey=seo1vv6blj18uhmnhfey3kifw&dl=0 

2 Replies

  • ddave84 , There is a problem when you use numbers on a continuous Axis. It can go beyond the available limits. Better to use dates or Categorical Axis

    • ddave84's avatar
      ddave84
      Frequent Visitor

      Unfortunately, that is the requirement from the end user.  They want to see metric by YYYYWW with x-y content lines.  I have tried a few other things but nothing is working.