Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello everybody.
I have a problem with a model. It contains only three tables, one of them is date, and the rest are fact tables, costs by date and shipments by date. The thing is that I am not able to "draw" in Power BI total shipments by date using date table, it does not work. Any idea?
Solved! Go to Solution.
Hi,
I have solved it by this way:
I have created another column in fact table which is date too, like this:
Calculated date = albaran_salida_fechas[create_date].[Date]
then I changed the relationship between these two tables, so "date" in calendario table is connected by"calculated date" with fact table. That´s perfect for me.
Thanks for your time
Hey,
can you please be a little more specific what you mean by "It does not work"
Check the following
Cheers
1. tables are related for sure
2. both columns have the same format
What I mean is that if I want to calculate shipments by date in a column chart for example, the chart does not show what I need. Instead of that show all data in "blank" date, not in each real date.
Hey,
my assumption:
the x-axis is picked from your table calendario.
Both tables are joined "Calendario-Date" <- "albaran...create_date" (the fact table).
The fact that all your data is shown on the element "(blank)", that for sure doesn't exists in the table Calendario, indicates that there is no match between the values of the joined columns.
This may happen if your Date column from the Calendario table is of datatype datetime "2017-08-10 12:00:00" and your column create_date is also a datetime column, but the values do not have a time portion like so: "2017-08-10 00:00:00"
This means, there are no matching values in both columns. For this reason I really recommend that you define the same datatye "date", this is different than the format used to present the values from the columns:
Hope this helps
I understood your last reply.
Both columns have same datatype "date" in this case, so I don't know why it does not show what I want.
Hey,
so it seems, that you have to provide sample data, from where your problem can be reproduced.
Regards
Hi,
I have solved it by this way:
I have created another column in fact table which is date too, like this:
Calculated date = albaran_salida_fechas[create_date].[Date]
then I changed the relationship between these two tables, so "date" in calendario table is connected by"calculated date" with fact table. That´s perfect for me.
Thanks for your time
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
218 | |
88 | |
73 | |
64 | |
60 |