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,
our customer asks for report, where he wants to see single line chart describing service satisfaction in 3 categories from 1 to 5
How modern is service ? From 1 to 5 (Old fashioned to Very modern)
Graphical design ? From 1 to 5 (Ugly to Very nice)
How expensive it is ? From 1 to 5 (Expensive to Cheap)
And he wants to see single line chart where 1 to 5 will be on X axis and on Y axis will be on left Y axis will be text label for 1 and on right Y axis will be text label for 5.
To be honest I have no clue how to achieve it
Attaching picture how it should look like.
Data are not important, I am able to do any kind of transformation, it is right now only about how to achieve visualization.
thanks
Solved! Go to Solution.
Maybe possible using Charticulator?
Proud to be a Super User!
Paul on Linkedin.
Hello,
problem solved. I have used Charticulator.
First I prepared data to have description on Left and Right Y-axis in one row + on same row Rating (0-5) created by each customer (ID). Rating value has summarization type "Average"
ID | Left Y axis | Right Y axis | Rating |
1 | Poor | Excellent | 1.3 |
1 | Expensive | Cheap | 2.8 |
1 | Ugly | Nice | 3.7 |
1 | Hard to learn | Easy to learn | 2.5 |
2 | Poor | Excellent | 3.6 |
2 | Expensive | Cheap | 4.8 |
2 | Ugly | Nice | 2.1 |
2 | Hard to learn | Easy to learn | 2.5 |
3 | Poor | Excellent | 3.5 |
3 | Expensive | Cheap | 3.0 |
3 | Ugly | Nice | 4.0 |
3 | Hard to learn | Easy to learn | 2.0 |
4 | Poor | Excellent | 2.2 |
4 | Expensive | Cheap | 3.3 |
4 | Ugly | Nice | 4.5 |
4 | Hard to learn | Easy to learn | 2.8 |
Then in Charticulator I used trick described by another guy at Youtube. I have created 2 PLOT SEGMENTS.
Both of them have on X-axis Rating value, one plot segment has on Y-axis value "Left Y axis" and second plot segment has on Y-axis value "Right Y axis" . Second plot segment Y-axis apperance is set to "Opposite" and the trick is, that those 2 Plot segments are then set to be completely overlapping, because data in both of them are completely same.
Result is as follows, sorry I was not still playing with formatting.....
Maybe possible using Charticulator?
Proud to be a Super User!
Paul on Linkedin.
you made my day sir, I did not catch info about this tool, after 2 hours of playing, I have job done !
It would be fantastic, and a important contribution to the community, if you could showcase how you achieved the visual (some screenshots maybe?)
Proud to be a Super User!
Paul on Linkedin.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |