Forum Discussion

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.

Question 1:

I would like to give the option to the end user to select two tables (maybe from a slider) and compare the two tables. How is this possible

Question 2:

Compare the two tables with and get the below results.

if file_a and file_b

if file_a and file_c

Ttheodosiou
Regular Visitor
3 years ago
as far as question 1, I have used interactions instead.
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
Ttheodosiou
Regular Visitor
3 years ago
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?
- Anonymous
  Not applicable
  3 years ago
  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