Chart Filter showing all data

[Anonymous]

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?

[HashamNiaz]

Hi !

Do you have any date dimension in your model.

Please share your current Model view diagram.

Regards,

Hasham

[Anonymous]

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

[Icey]

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

[HashamNiaz · Accepted solution]

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,

[Fowmy]

@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

[Anonymous]

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