data not getting displayed while using options in slicer

[rtneupane]

Hello

My problem looks  simple however got stuck on it for some time. i have a tabular display of data by fiscal period. when i select all, i am getting full display. but when i select any option in slicer,  i get data only till current period.  Pls help if anyone has faced this situation. full display when selecting allpartial display when selecting either of the options

[v-yiruan-msft]

Hi @rtneupane,

Is it possible that the selected company Ime only has data onto these time period , there is no data in other period ? Also , have you applied any visual/page/report level filters other than slicer ? From your screenshot , I can't find the root cause of the incorrect data display. If it is convenient , could you please provide me your PBIX file (exclude sensitive data ) ? Thank you .

Best Regards

Rena

[rtneupane]

both lmw and lme have data throughout. I will make a file for you and share . the file only has sensitive data. so i need to make a dummy file for you to view.

[Mann]

Hi @rtneupane 

You might be getting this as a result of your calculation.

Do you might sharing the calculation and insight into your dataset. If possible share your report through drive.

Mann.

[rtneupane]

i also suspect the same. I will share the file in few days as I need to make a dummy file for your viewing

[v-yiruan-msft]

Hi @rtneupane,

Thanks for  your reply. I will help check it once I got your sample file.

Best Regards

Rena