Forum Discussion

sapankumaarjain's avatar
sapankumaarjain
Regular Visitor
5 years ago

Arithmetic Operation Resulted in overflow

Hi Team, I have created a simple report with 2 slicers but on selection if the values are beyond 3700 lines I am getting above mentioned error in the 2nd slicer. Its the latest version of Power BI...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi sapankumaarjain 

Please show me your data source and your connection mode.

Can you sell all values in Slicer2 without any filter in Slicer1?

I have a test by geting data in Excel and using import mode.

My Sample table have two columns Level1 and Level2.

Level1 has three categorys A (2714 rows in Level2), B (7002 rows in Level2), C (200rows in Level2). 

When I select B in slicer1 (built by level1), slicer2 (built by Level2) works well.

And Desktop has upgrade, please update your desktop to the latest version (2.87.923.0 2020/11/25)

 

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

 

sapankumaarjain's avatar
sapankumaarjain
Regular Visitor
5 years ago

Hi Rico,

 

Data Source is Snowflake in direct query mode. Without any selection in slicer 1 yes it shows data.

 

Meanwhile I will update and check once.

 

Regards,

Sapan

  • sapankumaarjain's avatar
    sapankumaarjain
    Regular Visitor
    5 years ago

    Hi Rico,

     

    In the updated version also I am getting same error. Also its not a numeric column.

     

    Regards,

    Sapan