Exclude specific columns in table rows filtering

[Hyunbin]

WHY my first message has been Marked as spam!? It's not...

Please help me

I have a set of bookmark & table & line chart.

And the bookmark 'Korea' include the table selected first row '삼성전자'(Samsung Electronics)

I have a set of bookmark & table & line chart.

And the bookmark 'Korea' include the table selected first row '삼성전자'(Samsung Electronics)

I wanted to use the stock name 삼성전자(Samsung Electronics) as a filter in the line chart below, but the right columns, 76,400 (price) and +0.79 (daily return), are all filtered as well.

The values ​​in the table change every day. I want only the stock name to be filtered on the line chart, but the problem is that the three values ​​on the right, not the stock name, are also filtered. Because of this issue, no line chart is drawn on the line chart below after the daily value update.

Like below.

The explanation was long. In summary, what I'm curious about is how to exclude unwanted columns when filtering by rows in a table, or how to use only the values ​​of one desired column as a filter.

[Anonymous · Accepted solution]

Hi @Hyunbin 

My suggestion is to replace the “price” "daily return" fields in your table visual with measures like the following:

Latest Price = CALCULATE(
    MAX('DataTable'[Price]),
    FILTER(
        'DataTable',
        'DataTable'[Date] = MAX('DataTable'[Date])
    )
)

 Using original “price ”field from your data table in a line chart.

This way, the “price” and “daily return” columns will not be affected when filtering with “Stock Name” in the table visual.

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