Forum Discussion

astivale's avatar
astivale
New Member
1 year ago

Filter Columns in Table based on Chart Selection (Field Parameters)

hello, i have a table that i set up using field parameters. right now i have 9 factors going across the top and various stocks being listed in the rows. this works fine and i need a table as opposed ...
Tutorial Requests
Akash_Varuna's avatar
Akash_Varuna
Super User
1 year ago

Hi astivale Could you try these please 

  1. Capture Selected Factor: Create a measure to get the selected bar chart value:

    SelectedFactor = SELECTEDVALUE('Factors'[FactorName], "All")

  2. Control Column Visibility: Create a measure to show/hide columns:

    ShowColumn = 
IF(
    ISFILTERED('Factors'[FactorName]) && 
    SELECTEDVALUE('Factors'[FactorName]) = MAX('FieldParameters'[Name]),
    1,
    0
)

  3. Apply Conditional Formatting:

    • Add Field Parameter columns to your table.
    • Use Conditional Formatting > Font Color or Background Color.
    • Set color to match the background when ShowColumn = 0.

This keeps the table dynamic based on chart selection.

astivale's avatar
astivale
New Member
1 year ago

Thanks Akash_Varuna. I don't think this is exactly what i am looking for. the problem i am trying to solve for is that i have many factors, they don't all fit on the screen at once. as such when i click, i dont just want the column to be blank, i want it removed so that all the relevant columns will shift over onto the screen.