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
Kat_00
Frequent Visitor

Field Parameter Selection in Table

I have a table with field parameters that can be adjusted using a slicer. The first column is always included and serves as a reference for the other columns from the field parameters. When I click on a row in the table, the row and related visuals are highlighted. However, when I change the selection in my slicer, the table loses its highlighting, but the visuals remain highlighted.

I would like the table's highlighting to be retained when the slicer selection changes. If this isn't possible, is there a way to automatically clear the highlighting?


Kat_00_0-1724835688214.pngKat_00_1-1724835738403.pngKat_00_2-1724835797024.png

 

2 REPLIES 2
ArnaldoSandoval
Frequent Visitor

Hi Cat_00

 

Perhaps this video help you implement a workaround.

 

How to Clear ALL FILTERS with a one CLICK Button 

 

Hope this helps,

Arnaldo

v-yangliu-msft
Community Support
Community Support

Hi  @Kat_00 ,

 

It's a pleasure to connect with our community.

As far as I know, this might be by design in Power BI. When your field parameter slicer selects [Group1], the table visual and clustered bar chart only display the values corresponding to [Group1]. When you click [Index]=5 in the table visual, both visuals will also display the values of [Index]=5 in [Group1].

vyangliumsft_0-1724902022124.png

When the field parameter slicer selects [Group1], the highlighted results in the clustered bar chart will not automatically clear and will automatically highlight the values of [Index]=5 in [Group2]. You need to manually clear the highlights of other visuals when switching the slicer selection.

vyangliumsft_1-1724902022127.png

 

Best Regards,

Liu Yang

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

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.