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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
anshenterprice
Frequent Visitor

Bar Chart based on the two dimensions and one measure

Hi Team
Source Data

DateScriptnamebuy/saleQuantity
5/6/2022TataMotosbuy50
5/6/2022Reliencesale-150
5/6/2022HIUbuy50
5/6/2022Titanbuy50
5/12/2022TataMotosbuy100
5/12/2022Reliencesale-50
5/12/2022HIUbuy50
5/12/2022Titansale-50
5/12/2022InfoSale-50


Note: whatever buy quantiy it always sale same quantity then sum will become be 0 for a date
Output:
Xaxis is the date and each script name in the BAr graph with the QuantiTY

anshenterprice_0-1652680942845.png

 

 
 
 
 

 

 

 

 

 

 

 

 

1 ACCEPTED SOLUTION
v-henryk-mstf
Community Support
Community Support

Hi @anshenterprice ,

 

Add the corresponding fields directly to the clustered column chart, or create a simple measure formula that will automatically group fields based on the fields in the legend:

vhenrykmstf_0-1654594264570.png

Measure = sum('Table'[Quantity])

vhenrykmstf_1-1654594320334.png


If the problem is still not resolved, please point it out. Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-henryk-mstf
Community Support
Community Support

Hi @anshenterprice ,

 

Add the corresponding fields directly to the clustered column chart, or create a simple measure formula that will automatically group fields based on the fields in the legend:

vhenrykmstf_0-1654594264570.png

Measure = sum('Table'[Quantity])

vhenrykmstf_1-1654594320334.png


If the problem is still not resolved, please point it out. Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

jaipal
Resolver III
Resolver III

@anshenterprice please download the file here

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.