Filter a Line Chart by measure using slicers

[Anonymous]

Hello, I have a line chart that shows land values by Canadian provinces annually. I have successfully added a year slicer, where I can filter what years the line chart shows. However, I also want a slicer that can filter by province, so that instead of showing 10 provinces on the chart, it only shows 3 for example. When I try adding a slicer, it gives me the option to filter by a province's value, but not by the province itself. I have attached of photo of what my desktop currently looks like, and I am trying to have the option to only display selected provnces instead of all of them. The year slicer works as intended. Thanks for the help. 

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

Slicers display elements in a column, not column names.

Please select the correct column as slicer option

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