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.
Hi cbruhn42 ,
Date Table - Time portion
This issue typically occurs when Power BI automatically aggregates or groups data by date only.
To resolve this, please verify that the DateTime column in your DateTimeAxis table is set to the Date/Time format, not just Date. In Data view, select DateTimeAxis[DateTime] and set the Data Type to Date/Time.
Within your chart's X-axis settings, set the Type to Categorical rather than Continuous. This approach ensures that exact timestamps are displayed, preventing automatic grouping into days or hours.
Chart actual temperature
If you wish to chart each raw temperature reading over time, rather than an aggregated value, you do not need a measure. Simply drag TemperatureData[Temperature] to the Y-axis and DateTimeAxis[DateTime] to the X-axis. Similarly, you can add RejectData[Reject Count] to the Y-axis.
However, since Power BI only allows measures on a dual-axis, you may alternatively create two simple measures:
TemperatureRaw = MAX(TemperatureData[Temperature])
RejectCountRaw = MAX(RejectData[Reject Count])
These measures will function as raw readings if your X-axis is sufficiently detailed, such as by minute.
Thank you.
Helper IIISo I checked and the DateAxis table has the column Date marked as a Date/Time and I've tried setting the x-axis to both categorical and continuous. Still having the same issue where nothing charts when I use Date on the x-axis and temperature on the y-axis.
Hi cbruhn42 ,
To create the best visualization, use a Line Chart with DateTime on the X-axis:
Choose a Line Chart.
X-axis: date time (not DateAxis) directly onto the axis.
Y-axis: Temperature onto the axis.
Formatting:
Set the X-axis to Continuous.
Ensure the X-axis data type is set to Date/Time.
- cbruhn42
These are teh steps I have taken and nothing is showing up. Just a blank chart. I'm stumped.
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.