Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
NotMyJob
Helper II
Helper II

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 🙂

 

 

 

 

1 ACCEPTED SOLUTION

Hi, @NotMyJob 

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

vyaningymsft_0-1712643094062.png

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

 

View solution in original post

5 REPLIES 5
v-yaningy-msft
Community Support
Community Support

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:

vyaningymsft_8-1712217028245.png

 

vyaningymsft_7-1712217019977.png


1.Create Parameter Fileds

vyaningymsft_0-1712216098249.png

vyaningymsft_9-1712217077756.png

 

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

vyaningymsft_10-1712217113967.png

 

vyaningymsft_2-1712216159836.png


3. Create relationship

vyaningymsft_4-1712216816935.png

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

vyaningymsft_11-1712217238089.png

 

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

 

Hi @v-yaningy-msft , 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?  

 

NotMyJob_0-1712254459268.png

 

Hi, @NotMyJob 

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

vyaningymsft_0-1712643094062.png

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
Helper II
Helper II

@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?

 

NotMyJob_0-1712141345946.png

 

amitchandak
Super User
Super User

@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

 

amitchandak_0-1712098067223.png

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.