Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 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?
Maybe like this?
User | Count |
---|---|
86 | |
82 | |
68 | |
66 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |