Report with a chart and a table where the table displays values from the chart performance question

[psychobunny83]

Hi everyone, I have a dashboard page that has 2 visualizations on it.  The top is a bar chart which shows total sales by month for the year, and below that is a table.  The table is there so that a user can click on one of the bar chart bars, and then display the values in the table below.

This all works fine, but the problem is that each of the bars on the chart probably contain about 15 records on the table, but with no filters, the table has probably 6000 records.  So when you first load the report page, the top chart comes up instantly, but then the table takes a good 5-10 seconds to load while it loads all 6000 rows into it.  You can then click a bar on the chart and the table filters down.

Is there a way to pre-filter down that table?  If I try applying a filter to it, such as only showing records created this year, it loads faster, but when you then click the bar on the chart, it only filters the table down to records in the current year and excludes ones.

Is there a way to either have the table load blank, or ideally load with a specific filter I choose, but then have clicking the bars on the chart above it still filter it down properly?  I hope that makes sense, thanks for the help as usual!

[Icey]

Hi @psychobunny83 ,

Did the advice provided by @Greg_Deckler solve the issue you encountered?

If it did, please accept his reply as solution to your question so that people who may have the same question can get the solution directly.

Best Regards,

Icey

[amitchandak]

@psychobunny83 , Not clear. You can use TOP N filter sat visual level

https://www.oreilly.com/library/view/mastering-microsoft-power/9781788297233/378a5195-3e98-4cc1-bcd3...

[Greg_Deckler]

@psychobunny83 - One thing I have done with this but it will depend on your circumstance. I have created a measure that checks if a column is selected such as using ISFILTERED, HASONEVALUE, etc. Lots of different ways to do it. If ALL records are in scope, return 0 or BLANK, otherwise return 1. Depending on your situation you might be able to use this to get a blank table to load. For example, you could use this measure as a filter in your table. It would only return 0 if ALL items were in scope.