Forum Discussion
Visual filtering on column except when value equals x
Hi,
I am trying to filter my map visual on a column called Category. The column values are as follows:
| Shopping Center |
| Retail |
| Food |
| Health |
| Entertainment |
I would like the visual to filter when a value is selected, but if the row value is "Shopping Center", I want to leave those data points on the map. How do I do this?
Anonymous in this case you should create a separate table for slicers and then based on the selection in this separate table, filter your data table.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
1 Reply
Anonymous in this case you should create a separate table for slicers and then based on the selection in this separate table, filter your data table.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡