Forum Discussion
hiding columns in Matrix
- Anonymous7 years ago
Hi Frank,
I was able to solve the problem by turning off word wrap in the matrix setting and dragging the field I wanted to hide.
Hi,
If you don't want to see particular column for different categories in the matrix then there is one solution.
For example,
From the above matrix and I want to see only
Current FY -> Actual, Budget
May 2020 -> Actual
May 20201 -> Actual, Budget and Var
So, for this I have created one another table where I am taking only those columns which I want to see in the matrix. As shown below
Categroy Table =
You can make this table by just entering data and loading into the power bi.
Next step is to create relationship between Sales table and Category table.
My sales table has a calculated column named "FY Bucket".
And now we will create the relationship between Category['FY'] & Sales['FY bucket']
Note that, as both table has multiple values in the column it will display Many to Many relationship only.
To avoid many-to-many relationship you can create bridge table.
Next step is calculating Actual, Budget and Var for corresponding columns. Here, I am creating measure for that, it's formula is given below.
Put your measure as Values into the matrix.
And here is the result:
Thank You! I hope you will like it.
Mine is a similar example; however, the string columns are measures. Would you know how to go about removing just one column similar to this example?