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 to a matrix because i need to sort by each of them at times. as such i pivoted the data. the next step i would like to take is to limit the columns based on selections in other charts on the page. for example i have a bar chart that i can click on on of the factors. i would then like the table to only show that column from the field parameter instead of always showing all. is that possible? i tried creating  a measure that finds the selected value but dont see a way to then limit the options in my slicer based on that..

Tutorial Requests

3 Replies

  • 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.