Forum Discussion
How to add rows in slicer
- 3 years ago
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] ) - 3 years ago
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.
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