topic Re: Chart Filter showing all data in Report Server

Chart Filter showing all data

Anonymous — Mon, 10 May 2021 11:09:19 GMT

Hi,

I'm building a column chart that shows the sales of differents clients and the chart can by dynamic changed by the viewer. When it changes, I'd like that the chart showed just the data of that specific cliente that I want to see, as well the start date of the chart should the start date that the client begin to shop in my store.

However, when I filter the clients, it shows all the data and date together, what makes a little bit durty, like the image bellow:

How can I build this chart to show only the client that I filtered?

Re: Chart Filter showing all data

Fowmy — Mon, 10 May 2021 13:16:20 GMT

Anonymous

How is your data model setup? Have you set up clients on a separate table or all of your data sit on a single table?

Insert a slicer for the clients and filter prior to viewing the chart in focus mode

Re: Chart Filter showing all data

Anonymous — Mon, 10 May 2021 18:11:48 GMT

It's all in the same table, the "sales table". It already has a slicer, but when I filter by client, the chart shows all the data, and I want to show just the slicer data

Re: Chart Filter showing all data

HashamNiaz — Tue, 11 May 2021 12:03:46 GMT

Hi !

Do you have any date dimension in your model.

Please share your current Model view diagram.

Regards,

Hasham

Re: Chart Filter showing all data

Anonymous — Tue, 11 May 2021 19:39:15 GMT

I'm not sure if it will be usefull, it's in portuguese:

Re: Chart Filter showing all data

HashamNiaz — Tue, 11 May 2021 22:12:19 GMT

Hi !

While plotting the chart, you are using Date column from Calendar dimension. If yes please also check that checked do no show blank rows property.

Regards,

Re: Chart Filter showing all data

Icey — Fri, 14 May 2021 07:06:24 GMT

Hi Anonymous ,

I didn't find a column named "Client" in your model. Could you check the relationship between the table with "Client" column and other tables?

Best Regards,

Icey