Forum Discussion

Ak_Pikachu's avatar
Ak_Pikachu
Frequent Visitor
3 years ago
Solved

Conditional Text box based on conditional format

I have a question, I want to display a text box visual, on condition basis

If none of values in Red: "Everything Ok"
If some values in Red: "Correct the Values".
I have a DAX that works in Table visual,but I need a text box visual conditionally

Please Help

AEverything Ok
bEverything Ok
cEverything Ok
dCorrect the Values


I got d in red based on a condition

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi

     

    Sorry, but only now i understood your problem.

     

    So, i created a calculated column that checks if the value from table1 matches table2

     

     

    Then created a measure that checks if any missmatched values are in scope

     

     

     

    Hope it helps

     

    FILE:
    https://we.tl/t-mHWtCBvMDy

     

    Kind regards,
    José
    Please mark this answer as the solution if it resolves your issue.
    Appreciate your kudos! 🙂

9 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi

     

    Just create a measure to check if the value "d" is in your column

     

    Your Measure = 
IF("d" in VALUES('yourtable'[yourcoulumn]), "Correct the Values","Everithing OK")

     

    Kind regards,
    José
    Please mark this answer as the solution if it resolves your issue.
    Appreciate your kudos! 🙂

  • Ak_Pikachu's avatar
    Ak_Pikachu
    Frequent Visitor
    3 years ago

    Thanks for the reply, 

    This has to be dynamic , I will have the values get changed.
    Not static, what ever the values in red they have to be considered
    If any values in red Display for "Correction"
    if no red Display "All Okay"

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      OK i see.

      Then use the same measure you've used for the red formating and put it in a card

       

      Check Values = 
VAR __tableAValue = SELECTEDVALUE ( TableA[Value] )
VAR __tableBValue = SELECTEDVALUE ( TableB[Value] )
RETURN
IF ( __tableAValue <> __tableBValue, "Correct the Values","Everything OK" )

       

      Kind regards,
      José
      Please mark this answer as the solution if it resolves your issue.
      Appreciate your kudos! 🙂

      • Ak_Pikachu's avatar
        Ak_Pikachu
        Frequent Visitor
        3 years ago

        Hi,

        I have tried but its working fine when names are added to table visual and this measure, But this measure alone in a card visual showing Always OK, even if the values are not matching

        Please help if there is a way to do.