Forum Discussion

olimilo's avatar
olimilo
Icon for Post Prodigy rankPost Prodigy
1 year ago
Solved

How do I get this date partition in the graph?

This one to be specific:

 

This is how I have our data set up:

 

 

But I am still not seeing a partition in the date field at the lowest level of the data:

 

 

 

 

Need Help

8 Replies

  • Rupak_bi's avatar
    Rupak_bi
    Icon for Super User rankSuper User
    1 year ago

    Hi olimilo ,

    Go to format visual ---> X-Axis   ----->  change the type from continulus to categorical. this will bring all the dates in the X axis.

    Hope this solves the ask. If so, Plz accept  as solution, else let me know the issue.

     

     

  • wardy912's avatar
    wardy912
    Icon for Super User rankSuper User
    1 year ago

    Hi olimilo 

     

     In order to view all of your months in your x axis, you need to select type = Categorical.

    Please see below, I have made the change in the bottom line graph

    I hope this helps, please give a thumbs up and mark as solved if it does, thanks!

     

     

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    1 year ago

    Hi olimilo 

    Change your X-axis settings to categorical, expand the hierarchy all the way down (expand icon appears on the upper left when you hover a visual)  and disable concatenation of the fields so they're grouped by hierarchy.

    • olimilo's avatar
      olimilo
      Icon for Post Prodigy rankPost Prodigy
      1 year ago

      Edit: Specifically, I can't find it on graphs that use a custom date hierarchy from my Calendar table:

       

       

       

      I don't see this option in the Line Chart visual's settings:

       

       

       

      • v-menakakota's avatar
        v-menakakota
        Icon for Community Support rankCommunity Support
        1 year ago

        Hi  olimilo  ,
        Thanks for reaching out to the Microsoft fabric community forum.

         

        I would also take a moment to thank Rupak_bi  , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference. 
        I hope the information providedbelow assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need. 

        Thank you.

         

  • Rupak_bi's avatar
    Rupak_bi
    Icon for Super User rankSuper User
    1 year ago

    hi olimilo ,

    you will get the caterogical option once you drill up the visual to the maximum level (Here, Year). do that and categorical will get enabled to select. 
    alternatively, you can right click on the X-axis date field (build visual pane) and insted of hierarchy, set the field as it is by the column name. that will also make all the dates visible. but in this case drill up/down will not happen.

     

    cheers