Forum Discussion
Active Relationship always showing blank
Hi bcdobbs, yes I've also check that and they are both already set to the same formatting and everything but it still doesn't work.
However, I finally got it to work by replacing the previsouly selected default Created On column (I also tried the default Modified On column but doesn't work too) with a new date column of the same date format, etc. and it works now. It is so weird but it is displaying the visualizations and is dynamic to the date ranges now.
Hi bcdobbs, yes I've also check that and they are both already set to the same formatting and everything but it still doesn't work.
However, I finally got it to work by replacing the previsouly selected default Created On column (I also tried the default Modified On column but doesn't work too) with a new date column of the same date format, etc. and it works now. It is so weird but it is displaying the visualizations and is dynamic to the date ranges now.
Community ChampionMight be unrelated. Be careful with difference beteeen "date format" and the columns data type. https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-data-types#datetime-types
Thanks for this but it doesn't seem to apply in my case since the formatting ang data within said column is consistent since it is from a Dataverse default column. That is why it is the column I wanted to select consistently for all my relationships but it's ironic that a created column works for it instead of the default one which worked for all the other relationships.