Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Reflect data

Hi Experts,

 

I have multiple tables and they are connected with Column which has "FY20 MMM-YY" format, And slicer are FY, Month, Year. 

 

When i select Month the results are reflacting, but when i select FY in slice for previouse Fiscal year all data reflact (Blank). 

 

Could your please guide how to fix it. results should be if i select the FY then it should display That year-Last month data and if select currant FY then it should reflact currant month data 

 

Please help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Can you clarify "reflact"?

  • v-lid-msft's avatar
    v-lid-msft
    Community Support

    Hi Anonymous ,

     

    Sorry for that, We cannot understand your data model clearly, Could you please provide a mockup sample based on fake data or describle the fields of each tables and the relations between tables simply? It will be helpful if you can show us the exact expected result based on the tables. Please upload your files to One Drive and share the link here.

    Please don't contain any Confidential Information or Real data in your reply.


    Best regards,

     

  • v-lid-msft's avatar
    v-lid-msft
    Community Support

    Hi  Anonymous ,

     


    Does this issue have been resolved?Could you please provide more details about it If it still not be resolved? Please don't contain any Confidential Information or Real data in your reply.

     


    Best regards,

    • Anonymous's avatar
      Anonymous
      Not applicable

      Issue got resolve but the table is not getting refreshed