Forum Discussion
edgwatson1
5 months agoRegular Visitor
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. P...
- 5 months ago
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.
- 5 months ago
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
OwenAuger
Super User
5 months agoAre 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.
- edgwatson15 months agoRegular Visitor
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.