Forum Discussion
Need support please
Hi,
If i have the below Database, and I need to make a report where i can have a filter per City, which means if I filter for CIty 1, he will give me the 2nd View:
Database:
View 2:
Xls Tbl:
| City Id | Task | Status | Date |
| City1 | Task_0 | Passed | 15/09/2022 |
| City1 | Task_1 | Not Started | |
| City1 | Task_2 | Scheduled | 20/01/2023 |
| City1 | Task_3 | Not Started | |
| City1 | Task_4 | Not Started | |
| City1 | Task_5 | Not Started | |
| City2 | Task_0 | Not Started | |
| City2 | Task_1 | Not Started | |
| City2 | Task_2 | Passed | 01/01/2023 |
| City2 | Task_3 | Passed | 05/01/2023 |
4 Replies
Zakaria_1980 it's simple, you need to use the city id column as a filter. Below for your reference. Hope it helps.
can you send the PBI rpeort for this case please.
Here it is, filter by city.pbix
I need to use card instead of Matrix.
