Allow Sorting, Measure based filter conditions(From all levels visual, page, report) on Columns in Matrix Visual

Dear Power BI Team,

In matrix visual, we face the problem of have conditions to be applied on Values which is on the Columns field. Most Power BI users and the clients feel the same way as to why Not in columns of matrix visual doesn't look for filter conditions based on measures and also sorting based on column values.

For Instance, I have the Year field on the columns, Revenue on the values, Category field on the Rows, and When I apply the visual level filter as Revenue is not Zero.

The expected outcome is, it should show as the data for Year, Category, and Revenue whose revenue is greater than zero.

Currently, in matrix visual, It shows the revenue those are zero's. Please refer to the below

Year | 2017 | 2018
Category | Revenue
ABB | 0.00 | 13,9983,939.00
DFG | 0.00 | 3,444,323.00

When I apply the visual level filter as Revenue is not zero, It should show as
Year | 2018
Category | Revenue
ABB | 13,9983,939.00
DFG | 3,444,323.00

Note Visual view matters. we know that we can have the Year field on the Rows that will get the expected output but the user desire to have the year on columns

If you could consider this idea, It would be really helpful for the power bi users as well as for sure it will satisfy customers.

Thanks in Advance,
Sarumathi Vikraman