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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
Anonymous
Not applicable

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!

Anonymous
Not applicable

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.

Anonymous
Not applicable

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

@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
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors