Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hoping to get some more assistance with a minor nueance with the Power BI desktop app. I've got a report showing 2016 trend vs 2015 trend. In the dataset I've got 3 tables:
1. 2016 Delivery Trend
2. 2015 Delivery Trend
3. Dates
I've used the "dates" table which listed every day from Jan 1 2014 - December 31 2018 in a single column. I did this to create a relationship between the various tables in my report (Ive got forecasting tables as well). From my understanding of relationships this allows me to use the Dates table for both 20016 Delivery and 2015 Delivery.
The issue I'm having is in the line graph for 2015 the dates are listed as 2016. January 2016, February 2016 etc. I'm not sure why this is happening and how I can go about fixing this. In the 2015 Delivery Data table the dates are all clearly from 2015. If I use the "dates" column from the 2015 delivery data I get the correct months listed but I'd like to continue using the relationship table to ensure everything is uniformed.
Can anybody explain where I've gone wrong here? I've included a couple of screen shots to further outline the logic.
It should work as @ankitpatira mentioned. What is in the "Values" field, a measure or a column?
@cshowe80 It should work if in 2015 table you only have 2015 dates. Make sure date columns in both tables are defined of type date under modelling tab.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |