The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Solved! Go to 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
hi, @gco
I think the best way is:
Best Regards,
Lin
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.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
82 | |
77 | |
47 | |
39 |
User | Count |
---|---|
150 | |
117 | |
67 | |
64 | |
56 |