Forum Discussion

MikeHendriks's avatar
MikeHendriks
Icon for Helper I rankHelper I
1 year ago
Solved

Corrupt 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 tot...
Need Help
  • MiKeZZa241's avatar
    MiKeZZa241
    1 year ago

    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-msft's avatar
v-saisrao-msft
Icon for Community Support rankCommunity Support
1 year ago

Hi MiKeZZa241,

Please refresh the page to see the "Accept as Solution" option, which you can find in the three dots menu mentioned above.

 

Thank you.

 

 

MiKeZZa241's avatar
MiKeZZa241
New Member
1 year ago

I know how it works, but it's not there...

 

 

  • v-saisrao-msft's avatar
    v-saisrao-msft
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi MiKeZZa241,

    Please try logging in from another system and check if the options are visible.

    Thank you.