Data Restriction in Visualization

[Selded]

I have two clients SGP and AAIL _Amax and column in my sales table called total sales. i am using the clustered column chart and plotting daily sales for novemeber. i have two slicers , one for client the other for date. When i select SGP the client slicer, i see data in th visualization from 1st to 15th but when i select AAIL_amax, i only see data from 1st to 3rd although there in data for 1st to 15th from the data view in the sales table. what could be happening as i dont have any other page filters or report filters in use.

thanks for the help

[v-jingzhang]

Hi @Selded 

I saw you are using Day from Date hierarchy on X axis. Try replacing it with the whole date without date hierarchy and check the result.

If it still fails, can you let us know if you are using a date table? If not, you could add a date table to the model and create a relationship between date table and sales table on date column. Then use date column from date table in the date slicer and on axis of the chart. Do You Need a Date Dimension? - RADACAD

If using a date table doesn't work either, please provide a sample pbix (removing sensitive info) which can reproduce this problem. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Selded]

this shows the filters controlling the visual @HotChilli 

[HotChilli]

The first thing to check is what filters are affecting the chart so hover the mouse over the funnel icon in the corner of the chart.

If that shows only the filters you expect then show us the data in the data view that you think is not being shown.

------------------

If you want a faster resolution, link your pbix and I'll have a look at it