Forum Discussion
filters
Many of these items should not be in the report but because i cannot figure out how to filter columns in a matrix. Open to adding sometype of indicator if required.
in this visual i want to exclude any item that has positive values in the column with production < 12 weeks. We should only have values where production under 12 weeks is zero or less and production is greater than 12 weeks.
A good example of the challenge is that item 00180 would not be on the report because it has some production < 12 weeks. The only ones that should be on the report are 5081796 and 5082178.
Hi Anonymous,
If your raw data looks like the one in below table, and you have the measure ( Measure=SUM('Table'[Value]) ) to get the value of Values field. You can create a measure as below and apply a visual-level filter on your current visual with the condition(Flag is 1) to exclude any item that has positive values in the column with production < 12 weeks...
DOH Product & Description Production indicator Value 00079 - SIM STAND TWIST Productin < 12 Weeks 2810 00081 - VOLU FEED 60ML DISP Productin < 12 Weeks 351 0009456 - SIM PREMATURE NPL AND RNG Productin < 12 Weeks 756 00180 -VOLU FEED 60ML Productin < 12 Weeks 1672 00336 PDLYTE GRP 1L BTL 8CT Productin < 12 Weeks 36686 00180 -VOLU FEED 60ML Productin > 12 Weeks 11200 00336 PDLYTE GRP 1L BTL 8CT Productin > 12 Weeks 40938 5082178-SIM ORGANIC ES 1.45LB Productin > 12 Weeks 25 5081776-SIM SENS 1.41LB/22/5OZ PWD 6CT Productin > 12 Weeks 55 5081777-SIM SENS 1.41LB/22/5OZ PWD 6CT Productin < 12 Weeks 0 5081777-SIM SENS 1.41LB/22/5OZ PWD 6CT Productin > 12 Weeks 12 Flag = VAR _selpdesc = SELECTEDVALUE ( 'Table'[DOH Product & Description] ) VAR _selpindicator = SELECTEDVALUE ( 'Table'[Production indicator] ) VAR _pdesc = CALCULATE ( MAX ( 'Table'[DOH Product & Description] ), FILTER ( ALLSELECTED ( 'Table' ), 'Table'[DOH Product & Description] = _selpdesc && 'Table'[Production indicator] = "Productin < 12 Weeks" && [Measure] > 0 ) ) RETURN IF ( _selpdesc = _pdesc, 0, 1 )If the above one can't help you, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
4 Replies
Anonymous
Turn on the Filter Pane under View Tab and apply the filter as I have done below to show only the items here the Production < 12 Weeks <= 0Anonymous
Create two measuresProduction< 12 Weeks = SUM( Table5[Data Production< 12 Weeks]) Production> 12 Weeks = SUM( Table5[Data Production >12 Weeks])Then insert them in the Values section of the matrix
