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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Filter selection as optional

Hi,

Can any one please help me on below requirement.

I have created two fields Factor 1 and Factor 2 using field parameter option. Currently i am selecting one dimesnion from factor 1 and one from factot 2 and these are visible in below table. But user want to use factor2 as optional filter when they haven't selected any thing from factor 2 filter then the dimension from factor2 need to hide from table if they select need to visble.

 

how to achive this?

 

Factor 2 filter logic is 

Factor 2 = 

 {
      ("AY Month", NAMEOF('Home Claims'[AYMonth]), 0),
    ("Transaction Type", NAMEOF('Home Claims'[Transaction type Group]), 1),
    ("Cover Type", NAMEOF('Home Claims'[CoverType]), 2)
}

 

pawwy1_0-1692788552565.png

 

5 REPLIES 5
Idrissshatila
Super User
Super User

Hello @Anonymous ,

 

then why don't you have factor 1 and 2 in the same field parameter and you can either add them both or one of them.

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Anonymous
Not applicable

Hi,

 

That is the requirement we need to  compare 2 fields at a time

Hello @Anonymous ,

 

You can still compare both of them at a time, because you can select both of them together.

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Anonymous
Not applicable

@Idrissshatila I am looking for how to put  second filter as optional. If i haven't select any thing from factor 2 it won't viisble in table if i selected it needs to be visible.

Hello @Anonymous ,

 

Refer to this video to see how to do it https://youtu.be/nWgPynP9XDM?si=isshVmF6h9R5EIxd

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.