Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
arca123
Advocate I
Advocate I

Column 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:

ShopSales, $
A5
A12
A3
A8
A7
B7
B6
B15
C4
C2
C5
C7
C10
C5

 

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:
arca123_0-1682589449567.png

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:

ExpectedResult.png

 

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 1
lbendlin
Super User
Super User

Maybe like this?

 

lbendlin_0-1682899723409.png

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.