Forum Discussion

jitpbi's avatar
jitpbi
Post Patron
5 years ago

Line and Stacked column chart datetime values

Hi,

 

In the line and stacked column chart, I am using datetime on x axis. The each date is visible multiple times on the x axis. Is there any way to show each date on x axis only once, it should not repeat 2 or 3 times?

 

 

Thanks

 

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi jitpbi 

    You could try to build a Date Hierachy by datatime column on X axis. 

     

    In the visual as below, left one use Date hierechy and right one build without Date hierachy.

    Time intelligence feature of powerbi feature will automatically create date hieracrchy for you. You could enable it in option and

     

    need to restart your PowerBi file once to have it enabled.

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

    • jitpbi's avatar
      jitpbi
      Post Patron
      5 years ago

      Hi Anonymous ,

       

      I am displaying time series data on the line chart, it has different values in 5 minutes interval. So, it shows a single data point ony on the line chart for the whole day when using date hierarchy.

      I need to display my entire data for the whole day on this line chart but date should not be repeated on the x-axis. Please suggest any other possible way to achieve this.

       

      Thanks

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi jitpbi 

        I think you want to aggregate datatime to data in X-axis without aggregating values in line and column charts.

        You could add a new column by datatime(only date) and use this column to build a matrix column. Then group two visuals to

        achieve your goal.

        My Result:

        Your demand is a good idea, while it is not supported to implement in Power BI currently.

        You can submit a new idea and vote up this idea for this function to improve the Power BI : Idea

        It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by

        other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in

        the future.

        You can download the pbix file from this link: Line and Stacked column chart datetime values

         

        Best Regards,

        Rico Zhou

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.