Forum Discussion
Using results from filtering to filter another visual
I have a matrix visual with material in rows and Year Week in columns. The values essentially show a running total with numbers that are positive, negative or zero. For any given Year ...
HI ahipon,
Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Hi Xiaoxin,
Below is sample pbix file with dummy data.
https://drive.google.com/file/d/1nVQDN_xLsl3MPWcFFKKgOCVa32xXnKMY/view?usp=sharing
There is a simple matrix with values from a measure that is working correctly. There are are negative and positive values. Currently all Materials are displayed. I would like to dynamic pick a YearWeek, determine what Materials where value is negative, then filter entire Matrix based on the list of Materials.
Thank you.