Forum Discussion
arca123
Advocate I
3 years agoColumn chart with line for every legend
Hi!
I'm trying to solve a problem, where I have a 'Line and clustered column chart'' representing 3 different shops and the average sales for each shop, but I would also like to show how items each shop sold.
This is the sample data I'm using:
| Shop | Sales, $ |
| A | 5 |
| A | 12 |
| A | 3 |
| A | 8 |
| A | 7 |
| B | 7 |
| B | 6 |
| B | 15 |
| C | 4 |
| C | 2 |
| C | 5 |
| C | 7 |
| C | 10 |
| C | 5 |
I've written two simple measures:
Average Sales = DIVIDE ( SUM ( Sheet1[Sales] ), COUNT ( Sheet1[Sales] ) )
Number of sales = COUNT(Sheet1[Sales])
With these I can get the following visualization:
Number of sales has 3 calculations, which are correct, however, there is no way to tell which dot belongs to which shop. Is it possible to move the dots over the corresponding column?
Sample of what I'm trying to achieve:
Could you please let me know, if this is even possible to do in the current visualization? If not, what are some alternatives I could do to achieve this result?
1 Reply
- lbendlin
Super User
Maybe like this?