Multi value filter/parameter

[annaka05]

Hello,

I have column with single values:

I have used it in my dashboard as a filter:

.

The problem is that I want to combine multiple of this values as a single parameters. I have tried to create parameter with comma/semicolon delimiter and add text filter to this column, but it didn't work.

Do anybody have an idea, how can I create multiple value filters?

[annaka05]

Hi!

Thank you for your reply. I need to create visualisation filter for end users. Now it looks like this:, but users want to have filter which contains multiple values (e.g. show data in visualisation which contains values {121 -,000 -, 119 -} from "group" column and that has to be one filter value). In other words, I want to add multivalue filters: 

Regards,

Anna

[Daryl-Lynch-Bzy]

@annaka05 - I would suggest creating a table with the List value labels for selection, and relate it to the main table.  In otherwise, just treaty it like an ordinary Product to Product Category relationship.

List Label	Value Key
142 -; 143 -	142 -
142 -; 143 -	143 -
511 -	511 -
121 -; 122 -; 123 -; etc	121 -
121 -; 122 -; 123 -; etc	122 -
121 -; 122 -; 123 -; etc	123 -
121 -; 122 -; 123 -; etc	etc

The slicer or filter will be based on the List Labal values, and this will filter fact table.

[annaka05]

@Daryl-Lynch-Bzy Thank you for your reply. I tried that way. I added new table with values delimited with semicolon and second label column. Then I created relationship between new and sales table (values column from new table to group column in sales table). Then added label column as filter to visualisation, and unfortunatelly it doesn't work. When filter has one value it is ok, but filter with more values displays nothing.

Maybe I am doing something wrong?

Regards,

Anna

[Daryl-Lynch-Bzy]

@annaka05 - you need to separate the values into separate rows and repeat the labels.  Like this:

The Grupa column will related to the fact table, so you can slicer and filter it by using Labels.  This is just a normal star schema feature of Power BI.

[annaka05]

@Daryl-Lynch-Bzy ok, now I understand. Problem is, that I have duplicated values in few group filters: e.g. 172, 415, 499/1, 499/2 and 172,499 and I can't add multiple label to one value:

Regards,

Anna

[v-yingjl]

Hi @annaka05 ,

Based on your screenshot, what is your expected output in this thread, could you please combine it with an example in details?

Like: 

I have duplicated values in few group filters: e.g. 172, 415, 499/1, 499/2 and 172,499

When facing with the dupilcated or simliar values, what the correct result should be.

Best Regards,
Community Support Team _ Yingjie Li

[Daryl-Lynch-Bzy]

Hi @annaka05 - you screenshot above has both Visualisation and Power Query filters example.  Do you need to filter the list in Power Query when importing the data, or do you need the end user to filter using Slicer?

[annaka05]

Hi @Daryl-Lynch-Bzy  I need this filter in Visualisation for end user.