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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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

4 REPLIES 4
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

Hi @gco, are you able to solve this

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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