Forum Discussion
Measure for a Visual Card
You've just changed the paradigm. With so many questions, the nested IF will not be a good approach. It will be better to create a 2 column table and and fetch data from that table into your table with the RELATED() or LOOKUPVALUE() function.
Hi Ashish,
If you look at the newer file I uploaded you can see that I was able to get the coloring working based on the competency. If I drop that into a table it all works. I am now trying to use the Card visual to display competency and rating based on the Name selected.
If I select Sue I want one Card to display the rating for the relationship, another card to display the rating for communication. Does that make sense? When I try to pull the rating to the card it is just giving me first rating.
With Bob and Communication selected, my file shows the correct answer.
I opened the old file from my downloads folder. Let me study this one. Thank you and I will let you know if I have questions.
Hi Ashish,
I reviewed this over the weekend and tried to follow as best I could with my limited knowledge. I tried to recreate this in my own dataset but it seems to not pull the info like yours did. I get (blank) on some of my criteria and then everything is not showing in the status list.
For reference this is what my ratings code looks like
Status 1 = if('Sheet1'[Attribute]<="Q2","Relationship",if('Sheet1'[Attribute]<="Q4","Communication",if('Sheet1'[Attribute]<="Q6","Influence", if('Sheet1'[Attribute]<="Q8","Decison Making", IF(Sheet1[Attribute]<="q10", "Analytic Ability", IF(Sheet1[Attribute]<="q12", "Risk Management", IF(Sheet1[Attribute]<="q14", "Teamwork", IF(Sheet1[Attribute]<="q16", "Leading and Supervising", IF(Sheet1[Attribute]<="q18", "Achieving Personal Goals and Objectives", IF(Sheet1[Attribute]<="q20", "Business Results Orientation", IF(Sheet1[Attribute]<="q22", "Learning and Researching",IF(Sheet1[Attribute]<"q24","Adapting and Responding to Change","Organizational Awareness"))))))))))))You've just changed the paradigm. With so many questions, the nested IF will not be a good approach. It will be better to create a 2 column table and and fetch data from that table into your table with the RELATED() or LOOKUPVALUE() function.