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
papuzu
Helper II
Helper II

Maintain table size with filter

Hello there, 

 

how to mantain same table size when filtering on the table ? I would not scale down one of the two table when the other is filtered . Please see example below. When digiting one of the rows the other table (which is of same size) show up only the selected row. I would like to remain same size and bleach the other rows not part of selection

 

Thnks 

filter.png

1 ACCEPTED SOLUTION
v-robertq-msft
Community Support
Community Support

Hi, @papuzu 

According to your description, I think the “Cross filter” type of interaction can perfectly meet your requirement, and you can just use the "Ctrl"+"c" to copy the table visual to maintain the table to the same size. Then you can turn on the “Edit interaction” option and select the interaction type to “Cross filter”:

v-robertq-msft_0-1623293699693.png

v-robertq-msft_1-1623293699696.png

 

More info about changing the interaction behavior

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

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

View solution in original post

4 REPLIES 4
Syndicate_Admin
Administrator
Administrator

You must select the table:

Visual Formatting > Visualizations > Visual Object > Column Headings > Text > Wrap Text (turn off)

Ejemplo 2.jpg

Best regards

papuzu
Helper II
Helper II

@v-robertq-msft thanks for your reply 

the idea I had in mind was to respect the original size of both the table and then "highlight" the common selection without losing one of the two table size. 

What I was missing probably in the storyline is that both table originally has same size, then when you select one components of the two you shrink the other according to the filtered item.  It would be great if , looking at example I've posted, also the second column would get highlighted the row being selected on first table (and not hiding all other rows) rather then filtering as applied now 

 

Thanks for your time , 

Hi, @papuzu 

According to your requirement, it seems that the only way to achieve this is to close the interaction between the two visuals and select the same data for them respectively, like this:

vrobertqmsft_0-1624352234946.png

 

You can also go to the Power BI Idea to submit a new idea so that people with the same idea can vote for you. I will also vote for you.

vrobertqmsft_1-1624352234948.png

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

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

v-robertq-msft
Community Support
Community Support

Hi, @papuzu 

According to your description, I think the “Cross filter” type of interaction can perfectly meet your requirement, and you can just use the "Ctrl"+"c" to copy the table visual to maintain the table to the same size. Then you can turn on the “Edit interaction” option and select the interaction type to “Cross filter”:

v-robertq-msft_0-1623293699693.png

v-robertq-msft_1-1623293699696.png

 

More info about changing the interaction behavior

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.