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.
Hi all,
I have a visual table that has 3 columns. columns 1, 2 and 3 are all from the same source table 'Production Stats'. The visusal table retrieves values from the columns but is fitered to show the past 5 days. The date column in the 'Production Stats' table does not include weekends but the main table does.
I want to add another column that pulls data from another table named 'Factory Flow' for the same dates, however when I drag this column into the table visualisations it is showing me a summed total rather than a daily total. Can someone please tell me where I am going wrong? I'm guessing I need to create a measure to do this?
Solved! Go to Solution.
@Anonymous ,
Assume your Date Table is joined to each of your Fact tables on Date. If this is correct, then use [Date] from your Date Table in your table visual. At the moment, the table visual is using Date from Production Stats.
This should resolve the issue.
Regards,
@Anonymous ,
Assume your Date Table is joined to each of your Fact tables on Date. If this is correct, then use [Date] from your Date Table in your table visual. At the moment, the table visual is using Date from Production Stats.
This should resolve the issue.
Regards,
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |