Forum Discussion
Helper ICorrupt Excel Pivottable; same number on all months
We have some Excel files connected to a semantic model hosted in Power BI. Worked perfect for long period but since a week we get users complaining about a behaviour that is completely wrong; the total number is also displayed on all months;
Nothing works expect a 'clear all' in Excel which empties the complete pivot. Then we can rebuild succesfully.
Did somebody have had this before? Every hint we can get is very welcome
Issue is fixed. It seems to be caused by a DAX statement with a filter on the monthnumber which gives back different values for the same DAX statement with the same pivottable. Very strange, but fixed it with KEEPFILTERS.
10 Replies
Issue is fixed. It seems to be caused by a DAX statement with a filter on the monthnumber which gives back different values for the same DAX statement with the same pivottable. Very strange, but fixed it with KEEPFILTERS.
v-saisrao-msftCommunity Support
Hi MiKeZZa241,
Great to hear the issue got fixed. Please accept your reply as a solution so that other community members with the same issue can find it more easily.
Thank you.
I don't see that button/option somewhere??
- pborah
Solution Sage
MikeHendriks are the excel files acting as data source to the semantic model or is the semantic model acting as a data source for the excel files?
Hi pborah the semantic model is the source for the Excel file
- v-saisrao-msft
Hi MikeHendriks,
Thank you for reaching out to the Microsoft Fabric Forum Community.
Can you please confirm whether you are exporting the data manually or using another application? This will help us address the issue more effectively.
Thank you
- v-saisrao-msft
Hi MikeHendriks,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
