Need support please

[Zakaria_1980]

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

[Zakaria_1980]

I need to use card instead of Matrix.

[AbbasG]

@Zakaria_1980 it's simple, you need to use the city id column as a filter. Below for your reference. Hope it helps.

[Zakaria_1980]

can you send the PBI rpeort for this case please.

[AbbasG]

Here it is, filter by city.pbix