Forum Discussion
Solved
How to add rows in slicer
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 ...
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] )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.
DimaMD
Solution Sage
Solution SageRohit_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]
)
