Forum Discussion
Filter the same measure in one bar chart visual by different visual filters from different tables
Hi, I have the following question:
I have one measure (A) and I want to put this measure (A) and a copy (B) in one bar chart visual. Then measure A should be filtered by 3 Filter visuals (X,Y and Z), all coming from different tables. And measure B should be filtered by 2 different Filter Visuals (V and W) also coming form different tables. Is this possible?
I try to make a measure which I want to compare in one visual with the same measure, but both measures should be in the same visual and be filterd by different filter visuals, which come from different tables. I know that you can use the ALL function to ignore a filter and I know that you can use multiple columns when you use ALL. But this is only working when the columns you try to ignore come from the same table... I try to ignore the filters coming from different tables....
1 Reply
- v-cherch-msft
Microsoft Employee
Hi RSPPBI
It seems you may check the relationships and then try to use ALLSELECTED Function. Below are some article about this function. Please share some data sample and expected output for your scenario so that we could help further on it.
https://www.sqlbi.com/articles/understanding-allselected/
https://www.sqlbi.com/articles/the-definitive-guide-to-allselected/
Regards,
Cherie