Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
Solved! Go to 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.
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
83 | |
71 | |
49 |
User | Count |
---|---|
143 | |
120 | |
110 | |
59 | |
57 |