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 Power BI Community,
I have a "time" column with 5 minute interval timestamps like 00:01:01, 00:05:01 and a number column which has decimal values.
How to aggregate values by hour and display the data Hourly on the Line Chart in Power BI.
I Used drill up it shows only daily data but not Every hour in a day.
Please give a solution.
Thanks&Regards,
Ibrahim.
Solved! Go to Solution.
You have fallen victim of the blue "i" - forced sampling because you have too many data points.
You need to pre-aggregate your data before you can render it in the visual. add a HOUR() column to your fact table and use that.
You have fallen victim of the blue "i" - forced sampling because you have too many data points.
You need to pre-aggregate your data before you can render it in the visual. add a HOUR() column to your fact table and use that.
User | Count |
---|---|
21 | |
19 | |
12 | |
9 | |
8 |
User | Count |
---|---|
30 | |
26 | |
15 | |
13 | |
10 |