Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
gco
Resolver II
Resolver II

Make a Table ReadOnly

Hello,

 

I have a table visual that i want to make read-only or just use for displaying and disable filtering.  Is there a visual that does this or can you make a suggestion on how to workaround my issue?

 

Issue:  I have a table visual that displays 3 columns.  Whenever i click on the table visual, it resets the other table views around it back to default or whatever is displayed when the report started.  I already disabled the Interactions.  I am thinking of converting the table visual to something like a card so that it does not affect other tables when i click on it.  But at the same time, i wanted to maintain the table structure visually.

 

Thanks

Glen

1 ACCEPTED SOLUTION

Hi @v-lili6-msft ,

 

i found the fix from this post https://community.powerbi.com/t5/Desktop/disable-selectable-value-from-table/m-p/471707/highlight/fa....  I was able to draw an invisible rectangle on top of my table visual that made the table unclickable.  Very clever idea.

 

Thanks again

Glen

View solution in original post

3 REPLIES 3
v-lili6-msft
Community Support
Community Support

hi, @gco 

I think the best way is: 

Change how visuals interact in a Power BI report

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-lili6-msft ,

 

i found the fix from this post https://community.powerbi.com/t5/Desktop/disable-selectable-value-from-table/m-p/471707/highlight/fa....  I was able to draw an invisible rectangle on top of my table visual that made the table unclickable.  Very clever idea.

 

Thanks again

Glen

Hi @v-lili6-msft ,

 

For some reason the interactions does not work well for what i was trying to do.

 

https://kcuboard-my.sharepoint.com/:u:/g/personal/gco_kitsapcu_org/Ebhvas5YggBFsM2cpc3a-0QBCs7Whp5q7...

 

In the link above, when i click on the Account Number on Table 1, table 2 gets filtered by Account Number.  And when i click on the Account Number or anywhere on Table 2, Table 1 gets reset to what it was originally.  I wanted Table 1 to not reset - i get this behavior when converting Table 2 to a Multi-row card.  But i want same behavior as the multi-row card, but wanted the looks of a table.

 

Thank you

Glen

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.