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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
ajitk15
Regular Visitor

Multiple Stacked Columns stacked with line chart

Based on data, could any one help me how to generate chart as provide?

 

Data:

DateIncoming-NewIncoming-AgeTransfer outRESOLVEDCurrent open
1-Jul51121
2-Jul30022
3-Jul40051
4-Jul31013
5-Jul20141
6-Jul00001
7-Jul10020
 StackedStackedLine

 

ChartWhatsApp Image 2024-07-10 at 09.58.05_1cbd18cb.jpg

1 ACCEPTED SOLUTION
v-tangjie-msft
Community Support
Community Support

Hi @ajitk15 ,

 

Thanks @amitchandak  for the quick reply. Please allow me to offer other idea:

(1) Click "Transform Data" to enter Power Query, select the [Date] column, right-click "Unpivot Other Columns", then copy the table, filter the [Attribute] column, and then click "Close and Apply".

vtangjiemsft_0-1720689153323.pngvtangjiemsft_1-1720689191220.png

vtangjiemsft_2-1720689238288.png

(2) Create a model relationship.

vtangjiemsft_3-1720689303649.png

(3) Create a measure.

Current open = CALCULATE(SUM('Table'[Value]),FILTER('Table',[Attribute]="Current open"))

(4) Then the result is as follows.

vtangjiemsft_4-1720689361459.png

 

Best Regards,

Neeko Tang

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-tangjie-msft
Community Support
Community Support

Hi @ajitk15 ,

 

Thanks @amitchandak  for the quick reply. Please allow me to offer other idea:

(1) Click "Transform Data" to enter Power Query, select the [Date] column, right-click "Unpivot Other Columns", then copy the table, filter the [Attribute] column, and then click "Close and Apply".

vtangjiemsft_0-1720689153323.pngvtangjiemsft_1-1720689191220.png

vtangjiemsft_2-1720689238288.png

(2) Create a model relationship.

vtangjiemsft_3-1720689303649.png

(3) Create a measure.

Current open = CALCULATE(SUM('Table'[Value]),FILTER('Table',[Attribute]="Current open"))

(4) Then the result is as follows.

vtangjiemsft_4-1720689361459.png

 

Best Regards,

Neeko Tang

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

amitchandak
Super User
Super User

@ajitk15 , if these are measures refer to my approach

Creating Clustered Stacked Bar Visuals with Calculation Groups and Measures: https://www.youtube.com/watch?v=Z1Jx1hPtzbM&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L

 

Use Creating Clustered with line, to have one measure on line

 

Or check out this visual

https://appsource.microsoft.com/en-us/product/power-bi-visuals/yavdaanalyticspvtltd1628223732998.clu...

 

 

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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