Forum Discussion

NaeemShahzad123's avatar
NaeemShahzad123
New Member
3 years ago

Row By Row Comparison

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 se...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

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.