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.
I have a table with values every 15 minutes, I would like to create a chart with hours in the x-axis, and the magnitude of the measured variable (Potencia R(MW)) in the Y-axis.
I have created a relationship between this table and my "Datestable", but it does not work.
Any help is welcome!
Solved! Go to Solution.
Hi @galvar1975
If my above post helps, could you please consider Accept it as the solution to help the other members find it more quickly. thanks!
Best regards,
Dina Ye
Hi @galvar1975
I figure that you’d like to create the chart with hours in axis, and MW in the values.
So I’ve added the Hour column in your fact table and place it in the axis.
Column = HOUR(Table1[FECHA-dato])
Best regards,
Dina Ye
I have to retrieve the hours and minutes, and it would be great if that could be done with a measure!
Hi @galvar1975
We’re not able to set the measure on X-axis. For any column to be used as an axis value, it should be a category.
So in this case, it’s preferred to use column rather than measure.
Best regards,
Dina Ye
Hi @galvar1975
If my above post helps, could you please consider Accept it as the solution to help the other members find it more quickly. thanks!
Best regards,
Dina Ye
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 |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |