Forum Discussion
Help needed with LookUp Table/List
Hello,
I am trying to do a radar/bar chart with some very basic values.
My final table should have all categories (Quality, Speed, Communication), the count of values (Very Good, Good, Bad) and as legend the lookup table / list (Very Good, Good, Bad). All categories point to the same lookup/list
Customer
| Customer Name | Quality | Speed | Communication |
| A | Very Good | Very Good | Bad |
| B | Good | Good | Bad |
| C | Very Good | Bad | Very Good |
LookUp
| Very Good |
| Good |
| Bad |
| ... |
hope anybody can help me with that simple issue
BR
5 Replies
To do that:
1. unpivot columns 2-4 in the query editor (just highlight your Customer Name column, right click on it, and choose unpivot other columns.
2. Load the table.
3. Get a Radar chart by hitting the ellipsis in the Visualization pane and choose Get More Visuals.
4. Put the Attribute column in the category field well and your value column in the values area (choose Count as the aggregation or provide your own measure).
5. Make a table visual with your Value column to show Very Good, Good, etc. to be used as a slicer.
This is what it will look like
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Thanks for your quick answer, but it seems that the Count function is not working with textfields.
it shows only the whole amount of the categories, not the separated (very good, good, bad) value
cousinitt13 , not sure I got it. You can join with all three Tables and use userelation to create formulas.
Please check how to use userelation
amitchandak Thanks for the reply, but I can't do more than one relationship to my lookuptable
I have about 16 categories (columns) which have the same "legend" values ("Sehr Gut, Gut, Akzeptabel, Schlecht")
here is a screenshot of the dataand my lookup/list table is very basic
so, in this case, I can't create 16 relations to this lookup table.
cousinitt13 , maybe you want to unpivot then
