Forum Discussion
PowerBI Matrix Visual apply "Column Filtering" only to certain values
Hi all, i have a question regarding a PowerBI Matrix. In my matrix I currently have 2 measures defined as Values (One is a text and the other is Cost). I now want to display my cost according to ...
thank you for the answer! However, this does not solve my problem. Maybe i can explain it visually. I have Hierarchy as rows in my table. Cost and text are values and The classification (into fix and variable) are the columns.
This is how my matrix should look like:
| Hierarchy | Text | Cost | |
| Fix | Var | ||
Hierarchy lvl 1 | Text 1 | 50 | 100 |
| Hierarchy lvl 2 | Text 2 | 20 | 10 |
| Hierarchy lvl 3 | Text 3 | 30 | 50 |
However, it currently looks like this:
| Hierarchy | Fix | |||
| text | Cost | text | Var | |
Hierarchy lvl 1 | Text 1 | 50 | text 1 | 100 |
| Hierarchy lvl 2 | Text 2 | 20 | Text 2 | 10 |
| Hierarchy lvl 3 | Text 3 | 30 | Text 3 | 50 |
I do not want the "2nd text column" to appear and I do not to just "decrease the width of the column". Is there some work around to use the column only on certain values?