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.
Hey community,
in a bubble chart i am showing the margins of our articels and want to set a reference line for the minimum margin for pointing out which articles are not profitable at the moment.
I know the analytics pane, but fixed values are not helpful. We have different product groups with each different minimum margins. At the end i want to be able to select a product group and see the margin of all articles which belong to the product group in reference to the minimum margin line.
Do you have any idea how to manage this? As an example the table below:
Group | Player | Salary | Reference Value |
Real Madrid | A | 200 | 400 |
Real Madrid | B | 500 | 400 |
Real Madrid | C | 300 | 400 |
Barcelona | D | 200 | 200 |
Barcelona | E | 500 | 200 |
Barcelona | F | 200 | 200 |
Manchester United | G | 100 | 300 |
Manchester United | H | 600 | 300 |
Manchester United | I | 100 | 300 |
Bayern München | J | 200 | 500 |
Bayern München | K | 300 | 500 |
Bayern München | L | 400 | 500 |
Best regards!
No good way since you can't put a measure in for a "Constant line". One thing that you could potentially do is to put a line graph behind your visual and tweak your opacity settings for your other visual to essentially have the line show through to your chart.
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 |
---|---|
114 | |
100 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |