Forum Discussion
Interactions Error
Hi Russ99
What's the relationship between customer and the categories that that customer bought products from and categories that the customer name didnt buy any products from? Are they from the same table? And which column do you put in slicer?
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hello,
thanks for your response. Each customer only buys 1 category of product. But within each category there are multiple customers. For example customer A only bought products from the Parts category but the parts category has other customers in addition to customer A.
I have the categories in a slicer and I have the customer names in a bar graph.
The issue occurs when i click a customer in the bar graph, the slicer does not adjust to only show the category that customer bought from. For example when i click customer "Kerluke" (who only bought from the "finished goods" category) the slicer still shows other catdfories such as "parts". If the user then clicks on "parts" in the slicer, than no data shows up in the cards and charts i have in the report, which is understandable because "Kerluke" did not buy any parts.
If when the user selected "Kerluke", the slicer adjusted to only show the "finished goods" category, then I think my problem would be solved.
Does this make sense?
thanks again for your help, it is much appreciated.
Hi Russ99
Oh I see. However, actually the values in filter can not be filtered by other visuals.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.