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 da...
Need Help
Tips and Tricks
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

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Anonymous ,

         

        I am already using a calendar table and still have the same problem