undefined

Anonymous · ‎07-23-2020

Hi All,

I have a matrix visualization in the following format.

There are 3 fields in the row.

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 🙂

AllisonKennedy · ‎07-23-2020

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 · ‎07-23-2020

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

I want the matrix to look like this

Anonymous · ‎07-23-2020

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

I should see only level1 data like this

AllisonKennedy · ‎07-23-2020

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