Filter on visual

[orana]

Hello,

Below is an example of my data set. I have a visual that shows "Sales This Year" for customers who use Mack based on their Delta (%). I use the page filter to vary the Delta (%) depending on what I'm interested in seeing (e.g.,>100%, <50%, etc.). 

I'm looking to see if there is a way to create another visual that allows me to use the above filter but shows if these same customers have purchased through distributor "other". For example, if I have the delta (%) filter = 50%, I would see the "sales this year" information in a bar chart for row 1. But in another chart, I would like to see that customer A also purchased $100 from the distributor "Other".

Currently, I have the visual set-up such that if I set the delta(%) to 50%, I will see row 1 in my bar chart, but the other visual will show me info from row 4

Distributor	Customer	Sales This Year	Sales Last Year	Delta (%)	Product
Mack	A	100	50	100%	AA
Other	A	100	100	0%	BB
Mack	B	200	0	200%	AA
Mack	C	100	50	100%	AA

[parry2k]

@orana it will be easier if you post some raw data and the measure you are using, and what the final expected output is?

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

[orana]

sure! See attached links

Power BI File 

Excel File