Hello! I'm brand new to Power BI and I've got a complicated question already.
I have a bunch of survey results that can be grouped by a number of different buckets. The survey questions are also grouped into categories.
I organized my visualization to show an average score by category. My tooltip shows the Category and the Average score (with no decimals).
I want to add a description to the tooltip, based on the average answer. For example, average score = 2 would return a description of "Level 2 means some projects are using best practice but not many."
I have data that links the score (1-5) and the description. In Excel terms I would do a vlookup: (average score,table of scores & descriptions,description column number, true). I can't figure out how to reference the average score and use that to find the related description. When I try bringing descriptions into the Tool Tips, I just get "Count" instead of the text.
Is this possible??
Thank you!
