Forum Discussion
Date as Axis
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
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! 🙂
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
