Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Date as Axis

Hi all,

I've been trying to have line chart with count of order per day Month, quarter, year but nothing seems to work when i add my dateCompleted metric as Axis.

 

i changed dateCompleted from date/time to date but nothing seems to be working. 

 

Can anyone help? 

 

I keep getting this.

 thanks, 

 

Need Help
Tips and Tricks

6 Replies

  • JarroVGIT's avatar
    JarroVGIT
    Resident Rockstar
    6 years ago

    What is the aggregation applied to PoID? See below example.  Also, what is the data structure? Are you using a date table for the axis and a fact table for the values? Or are you using the DateColumn from the FactTable? 

     

    Kind regards

    Djerro123

    -------------------------------

    If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

    Keep those thumbs up coming! 🙂

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I applied count to PoID and "dateCompleted" is part of the fact table. I wrote a query that has all the info that I need for my analysis. 

       

      Thanks, 

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        HI Anonymous ,

        I think your date fields have link to other table dates field and they prevent the 'date intelligence' analytics on your date fields, right?

        Auto date/time in Power BI Desktop 
        If this is a case, I'd like to suggest you create a calendar table to link two tables to fix auto date intelligence feature, so that your value fields can be summarized by corresponding data hierarchy.

        Regards,

        Xiaoxin Sheng