cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mikail
Frequent Visitor

How to transform Line and Clustered column chart to Line and Stacked chart

Hello, powerbi community! I would like to transform Line and Clustered column chart to Line and Stacked chart. The Line and Clustered column chart consist 3 measures as a data source. However while transforming I just dont want to stack measures which default ability of line and stacked charts. The 2 measures has certain amout of data in common. For example Total Vehicle Sales = Car Sales + Van Sales. As it can be seen below total sales depicted with yellow column and car sales with orange. I would like to transform it to second visual. Yellow is again total sales and orange is car sales. The total sales exceeding slightly car sales because it includes small sales number of van sales. 

 

Mikail_0-1632988934611.png

Mikail_1-1632988980566.png

 

Thanks in advance! 

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

Hi  @Mikail ,

 

First create a dim table as below:

vkellymsft_0-1633422620943.png

 

Then create a column as below:

rank = RANKX('Table (2)','Table (2)'[Measure 2],,DESC,Dense)

Then copy column category and make it sort by rank:

vkellymsft_1-1633422690736.png

 

Then use the copy one as column series and you will see:

vkellymsft_2-1633422744582.png

Check my sample .pbix file attached.

 

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

View solution in original post

2 REPLIES 2
v-kelly-msft
Community Support
Community Support

Hi  @Mikail ,

 

First create a dim table as below:

vkellymsft_0-1633422620943.png

 

Then create a column as below:

rank = RANKX('Table (2)','Table (2)'[Measure 2],,DESC,Dense)

Then copy column category and make it sort by rank:

vkellymsft_1-1633422690736.png

 

Then use the copy one as column series and you will see:

vkellymsft_2-1633422744582.png

Check my sample .pbix file attached.

 

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

Pragati11
Super User
Super User

Hi @Mikail ,

 

Can you add details to your query please like screenshots, measure used, existing chart created, etc.?

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

 

Thanks,

Pragati

Best Regards,

Pragati Jain

MVP logoDACertAzCert

LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!