Forum Discussion
Anonymous
2 years agoNot applicable
Filtering the line graph visual based on time
Hi, I'm trying to make a line graph on powerbi, that represents the number of sales happening over time of the day. But i want to represent only the peak hour sales. The table looks something like...
- Anonymous2 years ago
I have used the bins in PowerBI and drill down options to make the graph more insightful. For now, this is good.
Thanks everyone for your help.
To do this:
Right click on the time field in the Data Section, and click "New Group"You could set the size of groups/bins you want to have on the visual (I've used 15 mins)
Now, by adding both bins and the time (in that order) in the visual along with the "Peak" filter. I'll be able to drill down on the visual.
Drill down basically just shows the individual sales made within the 15 min bin (when I click on a data point on the above graph).
amitchandak
2 years agoSuper User
Anonymous , You can create an hour column and you can use that in the slicer
Hour = hour(Table[Time])