Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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.
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.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |