My import sales table the period start from 2017 but when plot chart only display 2020 ?

[Anonymous]

Hi All

My data table shown that my sales table date start from 2017 Jan , But when i plot the chart , for year , it only display 2020 only. may i know where go wrong ? it go same for YearMonth Bar chart , only display 2020 monthly sales , and LYTD sales does able to display the amount. ( First time i encounter this issue , after i load from sharepoint )

My master calendar expression also start from 2017.

[VijayP]

@Anonymous 

Check whether there are any external filters selected accidentally. Also hope you are using DateDim Table

[Anonymous]

Hi vijay

There is no external filter. 

May I know what is date in table ?

I am using chart to check.

When I add year to slicer only see 2020.

[Anonymous]

@Anonymous seems like some filters are applied for testing you can create a new page in power bi destop try to add date field to table ...and would like to check if you are using any parameters, which will also filter the data

[Anonymous]

Hi All

Thank you every for your sharing.

From below screen shot , you can notice that my raw data file have 2019 data. But the Table or chart only can display 2020. Bwlow is my sample PBI file :-

https://www.dropbox.com/s/kcl5c4hl6674t83/PB_TDS_V021.pbix?dl=0

[Anonymous · Accepted solution]

Hi @Anonymous ,

Could you tell me if your problem has been solved?
If you are still confused about it, please provide me with more details about your table and your problem or reshare me with your pbix file. The file you previously shared appears to have been deleted.

Best Regards,

Stephen Tao

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