Forum Discussion

soderqvistn's avatar
soderqvistn
Helper I
1 year ago
Solved

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

 

  • 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.

5 Replies

  • 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.

  • Anonymous's avatar
    Anonymous
    Not applicable

    soderqvistn ,

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

    Regards,

    SK

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi soderqvistn ,
    Thank you andrewsommer  and Anonymous  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.

  • Anonymous's avatar
    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's avatar
    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!