Forum Discussion
Date as Axis
Resident RockstarWhat 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! 🙂
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,
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
Hi Anonymous ,
I am already using a calendar table and still have the same problem
- 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! 🙂