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,
I am using a direct query to an oracle database, all data retrieves back, the data includes
a column called "When" this is a Date / Time column.
a column called "Timing" this is a decimal value i.e. represents seconds.
So, overall this data represents timing over 5 minute intervals during the day. Ihave uploaded an image of this data.
I want a line chart to represent this data. The Axis to represent the "When" Column, and the "Timing" represents Values. PowerBi does not work here and I get the errorCant display this visual. And, powerBI assumes I want to count the "Timing" data, I dont I just want the Axis to displat "When" and the values to display Values a simple line chart.
Why does this not work, is this becuase I have a direct query ?
Solved! Go to Solution.
thanks for your response, though this did not help. Instead the timeline precision was too great for lineChart. I changed precision to 3 decimals and it works. Also not your suggestion of conversion wont work for direct queries.
Hi @dduffy,
Current line chart not support time type as axis.(it only support date type and text)
For your scenario, please add a calculated column to store the converted string value or whole number, then use it on line chart.
Regards,
Xiaoxin Sheng
thanks for your response, though this did not help. Instead the timeline precision was too great for lineChart. I changed precision to 3 decimals and it works. Also not your suggestion of conversion wont work for direct queries.
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |