Forum Discussion

Avivek's avatar
Avivek
Post Partisan
5 years ago

Alternative for drilldown function

I have a table which has ad, vp and sales rep name along with some other data which are in the form of text. And hence I cannot use a matrix to see this visual.

Now I want to see the AD's, VP's, Fieldsales and Sales Rep in this table visual.The function is how drill down works, for eg if i click on VP it should show the AD, when AD selected it should show me the fieldsales and so on. Something like as shown below;

 

Any idea or solution is appreciated.

Need Help

9 Replies

  • MFelix's avatar
    MFelix
    Super User
    5 years ago

    Hi Avivek,

     

    Not really sure about the structure of your data because you refer that you have "ad, vp and sales rep name along with some other data which are in the form of text" but I only see the AD column, does you AD column includes all the other information or are they at different columns?

     

    If they are in the same column how do you know the difference between them? Do you have another column that is used to differentiate this classification?

     

    • Avivek's avatar
      Avivek
      Post Partisan
      5 years ago

      MFelix , ad, vp , sales rep are all in different columns but same table

      • MFelix's avatar
        MFelix
        Super User
        5 years ago

        Hi Avivek,

         

        If the columns are on the same table you just need to use the matrix visualization and place the columns you need in the rows that will give you an hierarchy and the plus/minus sign will allow you to make the open and close of the values.

         

         

  • VijayP's avatar
    VijayP
    Community Champion
    5 years ago

    Avivek 

     

    In Power Query Editor you can Get a Column using Column from Example with only the name of VP/or other required names

    then you can easily use the same in the matrix without any additonal hassel

    Vijay Perepa