Can filter behavior change in powerbi

[changhai]

I have two tables in Azure Datawarehouse, and I want to use powerbi to build some reports. The simplified structure of the table is as follows：

create table [dbo].[app]
(
[app_uuid] [uniqueidentifier] NOT NULL,
[version] nvarchar(20) not null,
[brand] nvarchar(255) not null,
[os] nvarchar(20) not null
)

CREATE TABLE [dbo].[app_conf]
(
[app_uuid] [uniqueidentifier] NOT NULL,
[line_no] [int] NOT NULL,
[text] [nvarchar](2048) NULL
)

The two tables establish a relationship based on app_uuid.

My requirement is to find the app_uuid with specific configurations which are stored line by line in column [text] of table "app_conf"  , and then join with "app" table to make some reports.

I tried use PowerBI's own filter

Now I have the following problems：

1、The default filter【"does not contain"】 behavior can't meet my requirements, through direct query mode, I found that the SQL sent to ADW is as follows（roughly simplified version), so by default the behavior is like #2 , but what I expect is #3.  Can this be implemented in powerbi?

2、I need regular expression support，but I didn't see any options.

3、Can I customize the filter in powerbi or have a third party plugins to fulfill my requirements.

Thanks!

[v-yuta-msft · Accepted solution]

@changhai ,

I'm afraid the advanced filter can't achieve your requirement. In direct query, you can only use SQL statement when you connect to the datasource.

 

However, if you can convert direct query mode to import mode, you can use dax fucntion do create a new table using function like CONTAINSSTRING()

Currently, both dax and power query doesn't support regular expression, I would suggest you use Python/R script instead.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[changhai]

Hi @v-yuta-msft , thanks for your reply.

My requiremnt is to query according to the user's input（no matter it is regular expression or just keyword), we don't know in advance what user input is.

Can users customize filter component according to our own needs?

Thanks!

[v-yuta-msft]

@changhai ,

I'm afraid this can't be achieved in power bi because power bi doesn't support dynamic calculate table. 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.