Forum Discussion

jx615k's avatar
jx615k
Frequent Visitor
6 years ago

Column Name

Hi Comunity Team,

 

Can a measure tretreive a column name? What I am trying to do is filtering data based on a column name.

 

Thanks and regards.

Need Help

7 Replies

    • jx615k's avatar
      jx615k
      Frequent Visitor
      6 years ago

      Thanks for your responce!

       

      I want to have 2 slicers (slicer 1 and slicer 2). In slicer 1 I can pick up one of different Items, lets say "Item A" then Slicer 2 will have values From Column A. If I select Item B from Slicer 1, then Slicer 2 will have values from colum B and so on and on. Basically I have many Date columns and the users will pick up 3 of those columns to filter data so any user can select Coumn A, B and C, while others can select C, F, Z..... etc. I Cannot have 1 slicer per column since I would require more than 40 slicers so it wont be a great option so my goal is having 6 slicers, 3 containing Items from A to Z and the other 3 will contain any column from Column 1 to column N.

       

      Thanks again for your kind support.

      • camargos88's avatar
        camargos88
        Community Champion
        6 years ago

        Hi jx615k ,

         

        You can create a measure and compare the values selected by the slicer and get the column. Example:

         

        Ricardo