Forum Discussion
Troubles with Date model relationships
Hi Anonymous ,
A strange observation I made is that a lot of the visuals are behaving as if each of the cells of my date columns were 'vector'. For instance, if I try to create a 'matrix' visual with one column being the "issue ids" and the other column being "created date", Power BI automatically creates "Earliest created date" when I put it 'created date' in "Values". On the Query editor, dates are set to "Do not Summarize", but its still doing it by default. I also click the arrow on the field that lets me swap to: "Latest, Count, Count (Distinct)" but I have no option to simply use the actual date value.
Please note that I'm obtaining this data from a PostgreSQL DB in "Import" mode (Not query). I'm suspecting that Power BI (2.88.1144.0 64-bit (December 2020)) has a bug and it is importing each cell of the data rows as a more complicated object.
This is not a bug and is by design. When you put one column into the Values field of a visualization, it will be aggregated if there is no "Don't summarized" option.
In addition, for other issues, could you share us a dummy .pbix file for test? Please remove sensitive information and real data.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super UserAnonymous it is really not clear, what data you are visualizing? What date column you are using in the slicer? You just simply shared a relationship which is good to know but doesn't tell anything. You need to provide more context. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
parry2k thankx for the reply. I tried to include pictures on my post but the post editor wasn't responding to my clicks.
"What data are you visualizing?"
I have a pie chart what shows me the distribution of the categories of the submitted issues (e.g. 20% Software, 70% Hardware, 10% other) that dates back over two years. My expectation was to use the slicer to dynamically filter-by-date the data presented by the pie chart.
"What date column you are using in the slicer?"
I have a Calendar or Date Lookup table that I created. Each row is a date, going back over two years. First column is in Date/Time Format, and it was 'Categorized' as a date column on the query editor. I created other columns based on the first one (Year, quarter, etc).
I created a one-way, many-to-one relationship between the "Date" column of my Issues database and the "Date" column of my Calendar lookup.
On the "Reports" view, I created a slicer, and I assign it the "Date" column of my Calendar Lookup table. Right now, all data dissapears from the pie charts when I move the left circle of the slicer, as if all data came from the same date (typical behavior of bad model Relationship)