Forum Discussion
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. ...
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
As far as the question 2:
Is it possible to get the value of slicer into a parameter and then generate a new table with removematchingrows?
Hi Ttheodosiou ,
I'm affraid that's not possible. You can not create a table based on slicer values. Even if you can, the table won't change after you select another value in slicer.
Maybe you could consider to use bookmark, but then you will need to bookmark all possible outcomes in advance.
Create report bookmarks in Power BI to share insights and build stories - Power BI | Microsoft Learn
Best Regards,
Jay