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,
In the scenario below i have a date, time and temperature column.
What we are trying to visualize in a chart is on the x axis the time and date like the Excel example below.
Who can help me visualise this?
Thanks,
Stefan
Solved! Go to Solution.
Hello there @Stefanve ! You can implement a similar solution to the one proposed in the following link. THe only difference is that you will have to add the "Time" field to the date hierarchy.
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
You can also check out my LinkedIn!
Best regards,
Gonçalo Geraldes
Hi @Stefanve ,
See the below ,the following result is what you want .
Base data:
Result:
create a new hierarchy ,use date and time.
Then create visual:
Final get:
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
I'm trying to do what you described here. I managed to create the pivot table and the hierarchy, but I don't know where to find the "Concatenate labels" option. How do you get there?
After I got the Pivot Table, I created a Pivot Chart, but I don't know what's next.
Here is how it looks like:
Thanks in advanced
Best regards
Josef
You're using Microsoft Excel, whereas the post you're replying to was using Microsoft PowerBI for Desktop.
You cannot follow his instructions in Excel.
Hello there @Stefanve ! You can implement a similar solution to the one proposed in the following link. THe only difference is that you will have to add the "Time" field to the date hierarchy.
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
You can also check out my LinkedIn!
Best regards,
Gonçalo Geraldes
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 |
---|---|
108 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |