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,
My imported measurement data is in format below:
Measurement MeasurementResult TimeStamp
temperature 14 7/9/2016 6:00:00 AM
humidity 95 7/9/2016 6:00:00 AM
dewpoint 13.2 7/9/2016 6:00:00 AM
I would like to have the data in format:
TimeStamp temperature humidity dewpoint
7/9/2016 6:00:00 AM 14 95 13.2
How would I do the transformations?
If you only want to show the report in your expected format. You can also use Matrix visual chart directly as below without any transformation.
Best Regards,
Herbert
Let me walk you through the screenshots for the solution.
Thanks for the detailed reply. How do I do the arrangement if I have multiple results in same kind of format?
Thanks, it works, but I would like to show the data in line chart or line and stacked column chart.
If you want to show the data in line chart or stacked column chart, you can do it without any data transformations. Just drag the columns into charts as below.
Best Regards,
Herbert
Hi,
My imported measurement data is in format below:
Measurement MeasurementResult TimeStamp
temperature 14 7/9/2016 6:00:00 AM
humidity 95 7/9/2016 6:00:00 AM
dewpoint 13.2 7/9/2016 6:00:00 AM
I would like to have the data in format:
TimeStamp temperature humidity dewpoint
7/9/2016 6:00:00 AM 14 95 13.2
How would I do the transformations?
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |