Forum Discussion
comish4lif
8 years agoHelper II
Box Whisker Runs Slowly
I wish to use the Box and Whisker display on a filtered/sliced set of data.
The problem is, when the page loads, there are >45K records in >1500 groups. So, it's not a surprise that the Box and Whisker slows down the page load - that's a lot of calculations. And I wouldn't want to display that - the volume prevents any meaningful insight.
Is there a way to suppress the drawing of the Box and Whisker until the Slicers have been set - or until there are fewer than a specific number of groups selected?
1 Reply
- v-piga-msftResident Rockstar
Hi comish4lif,
What about creating parameters in Query Editor and filter the data then create the Box and Whisker chart in Report view?
For reference:
Using Query Parameters in Filter Rows
Best Regards,
Cherry