Forum Discussion
Helper IIINeed Help Identifying Compaing Column Values
Hi cbruhn42 ,
I understand you're still facing the issue despite following the steps. Since I'm getting the expected output on my end,Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
If you want to have your question answered quickly and avoid many back and forth, you should read this excellent article with lots of useful tips.
Super UserHi cbruhn42 ,
To analyze the relationship between temperature (Table A) and rejects (Table B) over time in a single chart, you need to align their Date/Time fields, even though the tables are structured differently.
Here’s a concise approach:
-
Create a Master DateTime Table: Make a table with all Date/Time values covering your data range, at the desired granularity (minute/hour/day).
-
Relate Both Tables to the Master Table: Create relationships from Table A's date time and Table B's Reject Date Time to the new master DateTime table.
-
Build the Visual: Use the DateTime from the master table as your X-axis. Use temperature (from Table A) and reject count (from Table B) as Y-axis values. Power BI will line up both values on the timeline.
Create a shared DateTime axis by relating both tables to a common DateTime table. This lets you compare temperature and reject counts together over time in your chart.