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
PBIfanatic's avatar
PBIfanatic
Icon for Helper V rankHelper V
6 years ago

Hi jx615k 

 

Please can you explain a bit more on what you are trying to achieve?

  • 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
      Icon for Community Champion rankCommunity 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

      • jx615k's avatar
        jx615k
        Frequent Visitor
        6 years ago

        Hi Ricardo!!!

         

        That is almost what I am looking for, is there a way I can replace the Dynamic table for a Slicer with date values?

        For instance, if Country is CAN, then show a slicer from column  "Canadian Holidays", if Country is JPN, then show a slicer from column "Japan Holidays" and if Country is USA then show a slicer from column "USA Holidays"

         

        Thansk in advance for your suport Ricardo 😃