Forum Discussion
Chart Filter showing all data
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?
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,
6 Replies
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 modeHi !
Do you have any date dimension in your model.Please share your current Model view diagram.
Regards,
Hasham
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,
