Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi All,
I'm in my first week with PowerBI and need some help.
I'm working with data at minutely intervals comes from many sensors and trying to
determine maximum/minimum values for a selected date(s). The data looks like below:
Original data
Date_time Sensor1 Sensor 2 ...
01/01/2017T12:00:00+10:00 28.1 18.7
01/01/2017T12:00:01+10:00 25.7 15.6
01/01/2017T12:00:02+10:00 25.6 18.5
Then I pivoted it in Power BI to
Date_time Sensor Measure
01/01/2017T12:00:00+10:00 Sensor1 28.1
01/01/2017T12:00:00+10:00 Sensor2 18.7
01/01/2017T12:00:01+10:00 Sensor1 25.7
01/01/2017T12:00:01+10:00 Sensor2 15.6
01/01/2017T12:00:02+10:00 Sensor1 25.6
01/01/2017T12:00:02+10:00 Sensor2 18.5
Then I grouped them, using group function in Power BI, into groups,
let's say Sensor1 and Sensor2 together for the above data. I managed to
create a graph out of average between those two sensors however when
I used Card to determine maximum/minimum value for a date(s) that I selected,
I got the maximum/minimum of individual sensor not the maximum/minimum of
average of the two sensors. For the above data, I got 28.1 but I wanted to get 23.4
for 1/01/2017, which is max of average between Sensor1 and Sensor2 (28.1+18.7)/2.
Any advice how I can achieve this (maximum or minimum)? This should be filtered to
date(s) selelected by users.
Thanks in advance for any help.
Regards
Jayana
Solved! Go to Solution.
Hi,
You may refer to my solution here.
Hope this helps.
Hi,
You may refer to my solution here.
Hope this helps.
Hi Ashish,
Brilliant, it works like magic.
Thanks for your help.
Jayana
You are most welcome.
Any help please.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
144 | |
73 | |
64 | |
52 | |
51 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |