How to add rows in slicer

[Rohit_23]

Hi,

Is it possible that graph to show values of selected rows which can be added to slicer.

i want to view only one test at a time.

Raw Data:

sample	TEST 1	TEST 2	TEST 3
A	2	23	12
B	5	45	56
C	3	3	9
D	12	56	1
E	5	86	54

how to add slicer in a graph such that it shows only selected row data in a graph??

Thanks

[DimaMD · Accepted solution]

@Rohit_23 Hi, You need to create a table with the names of your measures, where Test1, Test2, Test3 will be indicated. then write measure Through SWITH

measure = 
VAR test = SELECTEDVALUE('table_test'(Colum_Test)
SWITH( 
    TRUE(),
test = "Test1", [Test1], 
test = "Test2", [Test2],
test = "Test3", [Test3]
)

[Rohit_23]

Sorry didnt get you solution, im have just started using BI for last few month.  can you elaborate what exactly i have do.

[Alex_Sawdo · Accepted solution]

I highly recommend you look into the field parameter structure in Power BI. This is something that is in preview at the moment and has to be turned on, but it will solve your issue perfectly. With field parameters, you can select the three test columns and dynamically switch between each one without having to write a manual switch table in DAX. This can be found in the modeling section within power bi desktop. 

[Rohit_23]

Hi @Alex_Sawdo, this sloution also worked for me, but its bit tricky

[DimaMD · Accepted solution]

@Rohit_23 Hi, You need to create a table with the names of your measures, where Test1, Test2, Test3 will be indicated. then write measure Through SWITH

measure = 
VAR test = SELECTEDVALUE('table_test'(Colum_Test)
SWITH( 
    TRUE(),
test = "Test1", [Test1], 
test = "Test2", [Test2],
test = "Test3", [Test3]
)

[Rohit_23]

Thanks a lot @DimaMD , this solution worked

[DataVitalizer]

Hi @Rohit_23 
I believe that you are using a matrix visual, you can display the column that contains values TEST in a slicer visual with an option of simple selection.
Did it work ? 👌 Mark it as a solution to help spreading knowledge 👉 A kudos would be appreciated