Forum Discussion
hiding columns in Matrix
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 Anonymous,
Does that make sense? If so, kindly mark my answer as a solution to close the case.
Regards,
Frank
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,
I have similar situation-want to hard hightlighted in yellow color column. Want to see total. I try to follow your solution but lost.
under which categary I should go for "turning off word wrap " and dragging field
Please
Thanks
hi
iam also facing the same issue can you please help me .i need to hide the order cases i want ordercases in total field.below i have marked i need to hide .
Someone else will probably have a better solution but this reminds me of one that I had a problem with because I needed 3 year's sales but only current year's budget. I found the cleanest solution was to write measures for each year and one for the budget then put them into a table. Had the advantage of giving me measures I could use for other calculations
So I think you could write a CALCULATE for each of your fill rates and then a total for your cases to build something similar. 🙂
If we squeeze columns, that will hide that column from report users but users who are exporting it to excel will still sble to view the hidden fields. Is there a way to hide from exported file as well.
Nice little workaround with the hiding of the column. 👍 Helped me out.
Just a note to say thank you. This solved a issue that was driving me insane
hi
iam facing the same issue but iam not able to find the word wrap filed in the latest version of power bi desktop can please suggest me which field i need to see.
It is called Text Wrap now--the easiest way I'm finding to deal with the new layout is using the search bar in the formatting section.
Hi, thank you for this hint. It is a nice solution for hiding columns and only showing the totals in a matrix visual. But I think this is only a workaround and it would great/nice to have such a feature available in Power BI Desktop in the settings of the Matrix visual. Btw. if you publish the report the to Power BI Service the settings are gone and the columns are all visible again. So at the end this workaround is only usable if you are not publishing the reports to Power BI Service.
Maybe a switch in the setting for "specific columns" named "Only show totals" or something else would be great. If this switch is selected for a specific column the values for this column will not be shown and only the total will be visible then.
Or in the visual settings itself, there we have at the moment three sections:
- Rows
- Columns
- Value
Maybe it is possible to add here two additional sections:
- Sub-Totals
- Totals
By adding the data th these sections you could then control which data is shown in which part of the visual.
I think this could be a very usefull feature request.
Regards,
Frank
Drag where?
