Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Continuous Line Chart is not reflecting as continuous

I have page views over time. Every time my website gets a visit Google Analytics gets an entry. 

I want to see my growth over time per month but it looks like a day view: 

 

I need it to look like this:

 

I have linked the Views table with a Calander table but I don't see the hierarchy.

This is how I created my simple date table and marked it as the "date table" -  "CalendarDate = CALENDAR(
    DATE( YEAR( MIN( 'Views'[Date])),01,01),
    DATE( YEAR( MAX( 'Views'[Date])),12,31))"
Need Help

3 Replies

  • Idrissshatila's avatar
    Idrissshatila
    Super User
    3 years ago

    Hello Anonymous ,

     

    can you show me the date field how its presented as a field in this visual.

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

    Follow me on Linkedin

  • Dhairya's avatar
    Dhairya
    Solution Supplier
    3 years ago

    Hey Anonymous 

    Please create a custom column using the below DAX Code and use that column as the x-axis in the line chart.

    Month = FORMAT(CalendarDate[Date], "mmmm")

     If this helps you then please give it a kudo and accepted it as a solution so that others can find it quickly while facing a similar issue. Thank You!

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous 

    If you do not see the hierarchy, it may be that the option is not turned on in Power BI Desktop, you can refer to the following picture to open the hierarchy settings

    Best Regards!

    Yolo Zhu

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