Filter 2 column in a single table

Yucel — Sat, 17 Oct 2020 06:46:37 GMT

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

if anyone can help me to solve this issue.

Thanks in advance for your assistance,

Yucel Emir

Re: Filter 2 column in a single table

Ashish_Mathur — Sat, 17 Oct 2020 08:19:42 GMT

Hi,

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

Hope this helps.