Forum Discussion
PowerBI - Matrix table, hide values used only for a visual calculation
Hi there
I have a Y axis with a list of names
And an X axis with 3 measures, A (a count), B (a count) and C (C is a visual calculation that divides A/B).
I only want to show C in the report.
Previously I seem to remember achieving this by going to the table view and doing 'Hide in Report' and it disappearing from the visual.
I have been trying to achieve the same but it doesn't hide it from the visual. I can drag the columns to 0px but the table doesn't look quite right.
Any ideas on how to hide a column from a matrix visual that are used for the visual calculation only? Wondering if this is a bug as I do seem to remember this working previously!
Are you wanting to hide fields from the visual as described here?
You have to be in "visual calculations edit mode" to see the show/hide icons. You need to edit the visual calculation to enter this mode.
Hi edgwatson1
Use a normal measure instead of a visual calculation — it’s cleaner and avoids this limitation entirely
--> C = DIVIDE([A], [B])
If this answers your question, please mark it as the solution
6 Replies
Hi this is what I wanted. Thank you so much, I was searching for this for a long time. It is a very helpful feature.
- Future_To_BI
Resolver I
Hi edgwatson1
Use a normal measure instead of a visual calculation — it’s cleaner and avoids this limitation entirely
--> C = DIVIDE([A], [B])
If this answers your question, please mark it as the solution - pankajnamekar25
Super User
Hello edgwatson1
You can’t truly hide columns that are part of the visual.
instead, redesign the measure so only the final result (C) is used in the matrix.
If my response helped you, please consider clicking
Accept as Solution ✅ and giving it a Like 👍 – it helps others in the community too.
Thanks,
Connect with me on:
LinkedInThanks for that pankajnamekar25. I am new to PowerBi so I was wondering if you have some advice on redesigning that measure.
Here is my set up - A and B are distinct counts of values from a table. C is A/B.
How might I set this up so that only C is shown in the table?
Any help much appreciated.
- cengizhanarslan
If C is just dividing A by B, you don't need a visual calculation at all. Create C as a regular measure (C = DIVIDE([A], [B])), then add only C to your matrix and leave A and B out of the visual entirely. That way there's nothing to hide in the first place.
