Filter 2 column in a single table

[Yucel]

Dear All,

I have an issue with filtering 2 columns in a single table.

I have a geography table where I have cityId and District as shown below.

cityId district

10         X

10         Y

11        W

12        Z 

10        D

and I want to have an output like this

District

X

Y

D

if anyone can help me to solve this issue.

Thanks in advance for your assistance,

Yucel Emir

[Ashish_Mathur]

Hi,

Create a slicer for CityID and select 10 in that.  In your Table visual, drag District.

Hope this helps.