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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

undefined

Hi All,

 

I have a matrix visualization in the following format.

karthikbv4_0-1595494683080.png

 

There are 3 fields in the row.

karthikbv4_1-1595494762998.png

 

Is it anyway possible to filter out en entire field like level2 or level3 completely through an URL filter like

?filter=pbi/level2 eq null.

 

The requirement is to filter an entire field or column  through the URL filter.

 

Any help is apprecited. Thanks 🙂

 

4 REPLIES 4
AllisonKennedy
Super User
Super User

I don't understand what result you want? How do you remove the entire level 2 and do you still want to see level 3?

Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Anonymous
Not applicable

When I apply the filter as ?filter=pbi/level3 eq 'null'

I want the matrix to look like this

karthikbv4_0-1595498357027.png

 

 
 

 

Anonymous
Not applicable

When I put the filter as ?filter=pbi/level2 eq 'null' and pbi/level3 eq 'null'

 

I should see only level1 data like this

 
 

Capture.PNG

 
 

 

 

 

 

I kind of see what you mean, but that's not a filter as much as it is editing a hierarchy, so not sure it can be achieved with any filter, especially URL filter. Can you describe why you need this and we can maybe offer alternative solutions?

Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors