Row By Row Comparison

[NaeemShahzad123]

I want to compare any of the two cities data in table ,

for example ; city-A and City-D , by selecting city-A from one slicer and City-D from other slicer.

then one row will be of city-A and the second will be of city-D.

It is possible by using edit interactions option of slicers but as per requirement I don't have to use edit interaction option.

Any idea how I can do this?

[Greg_Deckler]

@NaeemShahzad123 Create 2 separate, disconnected tables for your slicers where you have one column and a row per city name. You can then construct a measure that is essentially a Complex Selector like this: The Complex Selector - Microsoft Power BI Community. Specifically in your case something along the lines of:

Selector Measure = 
  VAR __City1 = SELECTEDVALUE('Slicer1'[Column])
  VAR __City2 = SELECTEDVALUE('Slicer2'[Column])
  VAR __RowCity = MAX('Table'[City Name])
  VAR __Result = IF( __RowCity IN { __City1, __City2 }, 1, 0
RETURN
  __Result

Then filter your visualization using the Filters pane and this measure set to 1.