Interactions Error

[Russ99]

Dear Community,

I have an issue when selecting two contradicting filters that seems to break my report. I have a top customers by spend value graph (name y axis, spend in £ x value, i then have another few visualisations including a map etc. On the top of my report i have a slicer called product category. When I click a name on the top customers graph to filter the report, and then click a slicer for product category (a category that the customer name didnt buy any products from), the rest of the visuals seem to break and display no data. It is easy to temporarily fix by unclicking all things i have filtered by but i am wondering if there is a permanent fix. For example if i click a name of the customer, then the slicer only displays the categories that that customer bought products from.

Any help is much appreciated

[v-xiaotang]

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.

[Russ99]

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.

[v-xiaotang]

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.

[Russ99]

@amitchandak thanks a lot, that youtube video was very helpful. I watched it and tried it in my report, it worked perfectly with 2 slicers, however the slicer didnt change when I selected an element in the graph. What do you mean by check that it is not blank? is this a step that should go into creating the measure? thank you so much for all of your help!!

[amitchandak]

@Russ99 , so when add measure as filter in slicer we check for measure is not blank

[amitchandak]

@Russ99 , Take a measure from fact(common table) and use that in visual level filter of category and check that it is not blank

refer

https://www.youtube.com/watch?v=cyOquvfhzNM

[Russ99]

@amitchandak do you have any other potential solutions? I am still unable to make this work. Thanks for your help on this issue so far.