Forum Discussion

Hyunbin's avatar
Hyunbin
Regular Visitor
2 years ago
Solved

Exclude specific columns in table rows filtering

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 '삼성전자'(Sam...
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.