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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
sagi_b
Helper I
Helper I

Dynamic filter

Hi,

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

sagi_b_0-1630226435521.png

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 /

11 REPLIES 11
v-luwang-msft
Community Support
Community Support

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
Helper I
Helper I

hi

the second example is better for me.

thanks

 

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 VahidDM_0-1630277938440.png !!

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

but its on PBIX report, i cannot create a column

but it cannot create a column

sagi_b_0-1630318585975.png

 

@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_0-1630311915827.png !!

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 VahidDM_0-1630229875026.png !!

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

sagi_b_0-1630233459750.png

 

Hi @sagi_b ,

Do you mean something like this:

Calvin69_0-1630279437428.png

 

or:

Calvin69_1-1630279455419.png

Thanks

H

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.