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

Conditional format fields as blank based on another field

Hi,

 

Is it possible for me to blank the other fields based on the field that's in the square?

so basically when Tillhörighet = Oanmälda then Kvalificering = Blank() and so on

soderqvistn_1-1742817422554.png

 

1 ACCEPTED SOLUTION
andrewsommer
Super User
Super User

The best way to tackle this would depend on how your model is set up.  If everything is coming from a single table then a simple calculated column with the IF statement will work and then you would replace your Kvalificering field with the new calculated column in your visual

 

Please mark this post as solution if it helps you. Appreciate Kudos.

View solution in original post

5 REPLIES 5
v-pagayam-msft
Community Support
Community Support

Hi @soderqvistn ,
we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.
If our response addressed your query, please mark it as Accept Answer and click Yes if you found it helpful.
If you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

v-pagayam-msft
Community Support
Community Support

Hi @soderqvistn ,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Still needed assistance, feel free to reachout!

Thank you.

v-pagayam-msft
Community Support
Community Support

Hi @soderqvistn ,
Thank you @andrewsommer  and @Karsurya12_03  for the quick response!

I wanted to check in on your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply that helped you or sharing your solution. It would be greatly appreciated by others in the community who may have the same question.

Thank you.

Karsurya12_03
Helper I
Helper I

@soderqvistn ,

 Are you expecting hightlighted 'Oanmälda'  name will change to blank() in entire rows?, Is that name is static or dynamic?

Regards,

SK

andrewsommer
Super User
Super User

The best way to tackle this would depend on how your model is set up.  If everything is coming from a single table then a simple calculated column with the IF statement will work and then you would replace your Kvalificering field with the new calculated column in your visual

 

Please mark this post as solution if it helps you. Appreciate Kudos.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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