Remove columns from Table (but keep in tool tip)

[michellepace]

Hi there,

I'd like to remove two columns, Reference and Person, from my table as shown. But, I would like to retain the information in my tooltip. Is this possible?

Thank you, Michelle

[v-diye-msft · Accepted solution]

Hi @michellepace 

I'd suggest you to create a custom tooltip rather than using the one by default, and then put the Reference and Person field into the tooltip. 

here's similar post for your reference: https://community.powerbi.com/t5/Desktop/How-to-Hide-Coloum-in-Table-Visualizations-to-Make-ToolTip/...

I'll draw it up for you if you can provide the dummy pbix. 

[venal]

@michellepace 

You can remove those two columns from the visual (Transactional Breakdown) by clicking the cross symbol in "Values"(Right Side).

But you can keep both columns in the tooltip.

If this post was helpful may I ask you to mark it as solution and give it some kudos?

[michellepace]

Hello @venal  (or anyone else who may be able to help)

When I remove the Person column (as shown in (2) below) it is also removed from the tooltip. How do I get Person back into the tooltip (but not into the table)?

[venal]

Please refer the below link.

http://www.mediafire.com/file/q5jr4zmna2s1knl/michellepace-Tooltip.pbix

If the issue is persists, please share the PBIX file to investigate more.

If this post was helpful may I ask you to mark it as solution and give it some kudos?

BR

Venal.

[michellepace]

Hi Venal, I'm afraid I don't think you understand my quesiton at all. Thanks for trying though. 

Can anyone else other than Venal please comment?

[v-diye-msft]

Hi @michellepace 

If my above post helps, could you please consider Accept it as the solution to help the other members find it more quickly. thanks!