Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
@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 data
and 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
https://radacad.com/pivot-and-unpivot-with-power-bi
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
95 | |
94 | |
80 | |
71 | |
64 |
User | Count |
---|---|
120 | |
105 | |
99 | |
81 | |
72 |