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).
Hi Anonymous
amitchandak Thank you very much for sharing!
For your question about the visual wanting to show sales only during peak hours, you can try to resolve this by filtering on peak hours.
I noticed in your screenshot there is a column that shows if that time period is a peak period, please try the following:
Filtered Vision:
Choose your line chart visual.
Drag the Peak Hours column to the Filters pane.
Set the filter to only show "peak" times.
If you still have problems, it is best to provide the pbix file and be careful to delete sensitive data.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Thanks for your reply. I've tried the filter, but it still shows the time in between the two peak hours on x-axis, without any sales on y-axis.