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,
This is a cleaner model to work with. Please study this carefully and let me know how this works. I have not worked on the colouring so far.
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.
