Forum Discussion

yaman123's avatar
yaman123
Icon for Post Partisan rankPost Partisan
5 years ago

Matrix table view after scheduled refresh

Hi all, 

 

I have been having an issue with a report which is run each month. The matrix table messes up and expands the MAX DATE column to show all dates when it should only show the max date for that month. This tends to happen after each scheduled refresh in the service. When i refresh the report in Desktop, it shows fine and i need to publish back to the workspace for the end user to view the report in the correct layout. 

 

This is what appears in the service after each refresh. 

Need Help
Show and Tell
Tips and Tricks

3 Replies

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi yaman123 

    Is the [Max Date] a DAX column? I guess maybe there is something wrong with it. 

    could you share your PBI file after removing sensitive information or a simple sample file having the same problem?

     

    Best Regards,

    Community Support Team _ Tang

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

      • v-xiaotang's avatar
        v-xiaotang
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi yaman123 

        thanks for your reply, but I guess we may need to check the PBI file otherwise it's difficult to solve it.

         

        Best Regards,

        Community Support Team _ Tang

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