Forum Discussion
Filtering the line graph visual based on time
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).
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).