Dynamic filter

[sagi_b]

Hi,

I would like to create 2 dynamic filter that based on data in table.

1. filter of True/False that filter all the lines that reached the 100% in column % Tagged ( measure that based on 2 other mesaures- # Pending/ # Cycles)

2. filter of True/ False for # Cycles> 0 /

[v-luwang-msft]

Hi @sagi_b ，

Could you pls share your pbix flie? And remove confidential data.

You could not create a column ,I think the connect type you ued is live connection.

Best Regards

Lucien

[sagi_b]

hi

the second example is better for me.

thanks

[VahidDM]

Hi @sagi_b 

Use Slicer and add filter column to that. then you can see 2 option to option to select true or false.

Did I answer your question? Mark my post as a solution!

Appreciate your Kudos  !!

[sagi_b]

i cannot put the filter 1 in th slicer, only in table and then it presents only 1 answer (True/False)

[sagi_b]

but its on PBIX report, i cannot create a column

[VahidDM]

Check this link

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-tutorial-create-calculated-columns

[sagi_b]

but it cannot create a column

[VahidDM]

@sagi_b 

Did you add Filter 1 as a column or measure?

Please add it as a column and then try it.

Did I answer your question? Mark my post as a solution!

Appreciate your Kudos  !!

[VahidDM]

Hi @sagi_b 

Add these two columns to your report and use them in slicer or filter:

Filter 1 = if([% Tagged]=100%,TRUE(), false())

Filter 2 =if([# Cycles]>0 ,TRUE(), false())

Did I answer your question? Mark my post as a solution!

Appreciate your Kudos  !!

[sagi_b]

HI,

i already created a filter like that, but how can i present the filter in the page with Both (false/True) options?

do i have to add the measure to the table?

I dont want to present the filter in the table? only in the yellow sign

[Calvin69]

Hi @sagi_b ,

Do you mean something like this:

or:

Thanks

H