Visuals taking too long to load

[souvik900766]

Hi !
My Data link:-https://www.dropbox.com/s/bdtc2t7g440xx7j/try.pbix?dl=0
My Visual is taking too long to load . Need some optimization help !

Thanks in Advance !

[Ashish_Mathur]

Hi,

Share some data, describe the question and show the expected result.

[souvik900766]

Hi @Ashish_Mathur ,

I have shared the power bi file itself .
My Data link:-https://www.dropbox.com/s/bdtc2t7g440xx7j/try.pbix?dl=0

Actually the visual (line chart) is taking too long to load. When I am switching between Value or Volume in Slicer, its keep on refreshing. I belive this is happening for COUNTROWS and FILTER.
My question is if you can suggest some measure or way around to make it faster.

Thanks in advance!

[Ashish_Mathur]

I still cannot help.  I will need a small dataset, a description of the question and your expected result.

[souvik900766]

Hi @Ashish_Mathur ,
The dataset:-https://www.dropbox.com/scl/fi/tm826pkz2ucu6qfoqhysu/case.xlsx?
dl=0&rlkey=mhxbdwjxuzngha2ptt624q5nk
Power BI dashboard:-https://www.dropbox.com/s/bdtc2t7g440xx7j/try.pbix?dl=0

My Problem :-
My dataset contains around 80k rows and want to show a line chart based on count of Top 99% product and Bottom 1 % product. I have a slicer that has value and volume. My line chart is taking atleast 25 Mins to load or refresh while switching between slicers.
I want help on how can I reduce the time from 25 mins to 1 mins or less.
Above is the excel file and power bi link.