Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

PBI Report - Multiple Slicers slow down the Performance

Hi Team,   I've created a PBI report (Data Source - SSAS Cube) with 45 slicers on the first page.   Based on these filter selections, data gets loaded into the table created in the second page (all...
  • Anonymous's avatar
    Anonymous
    7 years ago

    Anonymous From my perspective this is a bit challenging because I don't know the business needs. From a really high level perspective. I don't try to create a single report that a business user can try to figure out their own insights as a starting point. I try to build out areas of interest and narrow down the scope to a particular area of business where fewer inputs are needed (slicers). The idea is to give them a Summary, intermediate and detail view of the interest area. Because I am producing insights with the visualizations on the page, and they can cross filter and interact, I reduce the number of inputs the user needs.

    That being said, I have no idea if the above is applicable, or if you would run into difficulties changing your approach because of requirements. Overall, you will need to explore ways to reduce the number of slicers, because no matter what you do, your report will always remain slow if you have that many active visuals on a page.