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 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?
Need Help

1 Reply

  • 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.