Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello all,
I'm new to Power Bi. I’m analyzing big dataset coming from multiple sensors. The frequency of sampling is 1 minute. Currently I’ve built a report where I can see the aggregated data per day and clicking on the single day, I can see how the values change minute by minute. I was able to do that creating the calendar and the timetable down to the minute. Now I’m stuck because I can see just one day at time, and I need to see more then one day to have an overview on what happened. If I use the time brush function I get the aggregated chart, but I need the punctual data. Is there any solution? I was not able to find one yet.
Thank you
Solved! Go to Solution.
Hi @Mircol ,
I have built a data sample for test. You could drag Date field to X-axis as well as Time to the Minutes field. And then use Drill down and disable the Concatenate labels option:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Mircol ,
I have built a data sample for test. You could drag Date field to X-axis as well as Time to the Minutes field. And then use Drill down and disable the Concatenate labels option:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-eqin-msft ,
Thank you very much for your help.
Putting together your suggestion with others, I was able to obtain the wanted results.
And using the time brush function I can “zoom in” on the specific period of time that I want to analyze.
First of all, thank you very much.
Here two screenshots. On one you can see the first rows of the dataset and on the other one the two graphs. On the bottom one, there is the detail (minute by minute) of the recorded values but just between 00:00 to 24:00.
Thank you
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |