Help needed with LookUp Table/List

[cousinitt13]

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

[amitchandak]

@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

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[cousinitt13]

@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 data

and my lookup/list table is very basic

so, in this case, I can't create 16 relations to this lookup table.

[amitchandak]

@cousinitt13 , maybe you want to unpivot then

https://radacad.com/pivot-and-unpivot-with-power-bi

[mahoneypat]

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

[cousinitt13]

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