March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
133 | |
91 | |
88 | |
64 | |
58 |
User | Count |
---|---|
201 | |
137 | |
107 | |
73 | |
68 |