Forum Discussion

Ttheodosiou's avatar
Ttheodosiou
Regular Visitor
3 years ago
Solved

Compare two tables by slider

Hello,   I am new to power bi and I would like your support on how to achive the below:   I have a couple of .csv files in a folder and i was thinking to import the folder and expand the tables. ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Ttheodosiou ,

     

    Question1:

    You could use slicers and measures.

    slicer1 = DISTINCT('Table'[Source.name])
    slicer2 = DISTINCT('Table'[Source.name])
    Measure1 = IF(SELECTEDVALUE('Table'[Source.name]) = SELECTEDVALUE(slicer1[Source.name]),1,0)
    Measure2 = IF(SELECTEDVALUE('Table'[Source.name]) = SELECTEDVALUE(slicer2[Source.name]),1,0)

    Question2:

    You can not use slicer to control which column to show in the visual.

     

    Best Regards,

    Jay

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Ttheodosiou ,

 

Question1:

You could use slicers and measures.

slicer1 = DISTINCT('Table'[Source.name])
slicer2 = DISTINCT('Table'[Source.name])
Measure1 = IF(SELECTEDVALUE('Table'[Source.name]) = SELECTEDVALUE(slicer1[Source.name]),1,0)
Measure2 = IF(SELECTEDVALUE('Table'[Source.name]) = SELECTEDVALUE(slicer2[Source.name]),1,0)

Question2:

You can not use slicer to control which column to show in the visual.

 

Best Regards,

Jay