Forum Discussion

edgwatson1's avatar
edgwatson1
Regular Visitor
5 months ago
Solved

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...
  • OwenAuger's avatar
    5 months ago

    edgwatson1 

    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.

  • Future_To_BI's avatar
    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