Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
Hi,
I am struggling to figure out how we can hide a column in matrix but not in total section or in other words, I would like to add a additional column in total section other than totals of values in matrix. The workaround which I found is turning off word wrap in the matrix setting and dragging the field I wanted to hide. However there is a problem in this solution. whenever there is a change in slicer then matrix is showing the column for the new data which I want to hide.
Could anyone help me how to hide the column in the matrix even new data shows up in matrix by changing the slicers/filters?
Thanks
Solved! Go to Solution.
I'm not sure what the problem is regarding changing the value in the slicer. See this example (both "word wrap" and "Auto-size column width are truned off in the formatting options):
To ensure that the column remains blank, use a measure along the lines of (in the above example, where I renamed the measure to "Previous Year" in the visual):
Hide Previous Year = IF(ISINSCOPE('DIM Product Ref'[Product REF]), BLANK(), [Previous Year])
If you need two columns of values per period, you can also create a hybrid table (attached is the sample file):
To be able to help you with creating a hybrid matrix please provide a sample dataset or PBIX file to work on, together with a depiction of the matrix you need.
Proud to be a Super User!
Paul on Linkedin.
See if this post helps:
Creating a custom or hybrid matrix
Or you can try turning off the "auto width" option in the formatting pane under columns and drag the column width to hide it
Proud to be a Super User!
Paul on Linkedin.
Nopes, this post does not help. Moreover, this is the simple feature and I am wondering if Power BI is not providing this feature.
There is currently no option to turn off elements/columns in a matrix. You either try hiding the column using the auto-width option in the formatting pane or create a custom matrix layout.
Proud to be a Super User!
Paul on Linkedin.
Hiding the column using the auto-width option is not working as when i change the value from date slicer it is showing me hided column for new data so the only option left is to go for custom layout for matrix. Could you please provide me sample pibx file of custom layout which hides one of the column in the matrix and keeping it in total section?
thanks
I've attached the sample file to the message
Proud to be a Super User!
Paul on Linkedin.
Hola @PaulDBrown ,
The solution, you attached is working when you have one column in the matrix view for date dimension which is month is your solution but is not valid if you have lets say 2 columns in the matrix for the date dimension So Could you please help me how to have more than one column in the matrix View?
I'm not sure what the problem is regarding changing the value in the slicer. See this example (both "word wrap" and "Auto-size column width are truned off in the formatting options):
To ensure that the column remains blank, use a measure along the lines of (in the above example, where I renamed the measure to "Previous Year" in the visual):
Hide Previous Year = IF(ISINSCOPE('DIM Product Ref'[Product REF]), BLANK(), [Previous Year])
If you need two columns of values per period, you can also create a hybrid table (attached is the sample file):
To be able to help you with creating a hybrid matrix please provide a sample dataset or PBIX file to work on, together with a depiction of the matrix you need.
Proud to be a Super User!
Paul on Linkedin.
Hi Paul,
I have downloaded your sample file "Hybrid Matrix 2 cols.pbix" and it is exactly what I am looking for. However I cannot see how to set it with 2 columns on page Hybrid 2 columns, what is the different between that page and Hybrid page. I try to place "value" from "Hybrid Table" into Columns of the matrix, but no changed.
Please help.
Thanks in advance
By the sound of it I would wager that you need to expand the columns to the lowest level, since there is a hierarchy of fields in the column bucket
Proud to be a Super User!
Paul on Linkedin.
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
94 | |
90 | |
83 | |
76 | |
49 |
User | Count |
---|---|
145 | |
140 | |
109 | |
68 | |
55 |