Forum Discussion

NotMyJob's avatar
NotMyJob
Icon for Helper III rankHelper III
2 years ago
Solved

Drop down list available?

I might not be phrasing this correctly, however I'm trying to figure out how to get a top level identifier (i.e., COM 01-01, COM 02-01, COM 02-02, COM, 30-1, etc) to appear as sole line items:

 

COM 01-01

COM 02-01

COM 02-02

COM 03-01

 

And then either have that top level identifier clickable to present:

COM 01-01

COM 01-01-A

COM 01-01-A1

COM 01-01-B

COM 01-01-B1

COM 01-01-C

COM 02-01

COM 02-02

COM 03-01

COM 02-01

COM 02-02

COM 03-01

 

I'm hoping these can be in a slicer?

Or, click on a top level identifier (e.g. COM 01-01 and have that and the sub identifiers appear in a table below the slicer.

 

To make it worse, I am horrible in DAX - just a very beginner in PBI.

 

Thanks if anyone can help or know that this just simple can't be done and I'll move on to see if there's a different approach to what mgmt wants 🙂

 

 

 

 

Need Help

5 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    2 years ago

    NotMyJob , if these are the two columns in the table with the data as you has shown, you can add both of them to the slicer

     

     

  • NotMyJob's avatar
    NotMyJob
    Icon for Helper III rankHelper III
    2 years ago

    amitchandak - this doesn't work for me somehow.  I either can get "Brand", or "Category", however not the drop down.  Here are the results of two different approaches, the one on the right is the "Category", and the one on the left is the "Brand".  Any ideas?

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, NotMyJob 

    You can refer to amitchandak reply, if it didn't solve the problem, you can try to use Parameter Fileds, below are the specific steps.
    My Data sheet:

     


    1.Create Parameter Fileds

     

    2. Create two Slicers by Parameter and Level1, then open the hidden field.

     


    3. Create relationship

    4. Put the Parameter Order to Filters pane and set by the following picture(Set the default display style).

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

     

    • NotMyJob's avatar
      NotMyJob
      Icon for Helper III rankHelper III
      2 years ago

      Hi Anonymous , i'm trying this now and have d/l'd the example file - thank you.  I've seen another report here at the company that has "+" signs that expand that category (if I'm getting the terminology right).  Would you know what that is specifically called so that I can look up that function?  

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi, NotMyJob 

        I think you are find the custom visual named Herarchical Filter, try this to see if it suits your needs.

        Best Regards,
        Yang
        Community Support Team

         

        If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
        If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

        How to get your questions answered quickly --  How to provide sample data in the Power BI Forum