Date as Axis

[Anonymous]

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, 

[JarroVGIT]

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]

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, 

[v-shex-msft]

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]

Hi @v-shex-msft ,

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

[v-shex-msft]

HI @Anonymous,

Maybe you can try to add calculated columns to external correspond hierarchy date fields from date value, then you can use these calculated columns on axis fields to summary records.

Regards,

Xiaoxin Sheng

[JarroVGIT]

Hmm then there must be something else wrong. What you are trying to achieve is very basic functionality (visual, grouping variable X (count of PoID) by variable Y (Date). If the datecolumn of the fact table is marked as date time (which it does seem to be from the looks of your first post), this just should work. 

Is it possible to share your PBIX? You can also privately share it with me by sending me a link through PM, then I am sure I can sort this out for you 🙂

EDIT: you already mentioned that you weren't able to share your PBIX in another post. See my post here to see if that helps you any further (also on this issue).

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! 🙂