Forum Discussion
Exclude specific columns in table rows filtering
- Anonymous2 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.
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.