cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

stacked and clustered column (basics)

Hello experts,

I am working on an indicator that has been produced based out of Excel. I had been asked to reproduce it in Power BI.

As per my collected info it seems clustered and stacked are not possible with PowerBI... Then I would appreciate to let me know if any "workaround to obtain the graph "Product Mix  as I am capable to obtain the accompanied table... In excel I would only nee to transpose values...

I achieve to create below chart based on calculated measures fields (thats why the % Sales need to be changed to % of total..not sure if correct...) Basically it shows contribution of top sellers in the portfolio and need to reduce long tail (slow movers)...

made chart.JPGexcel graph.JPG

 

thank you all in advance

 

BR

Luis

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: stacked and clustered column (basics)

Hi @kaycana ,

 

As you refer in Power BI when the values are too smal they aren't visible, you can make a custom formatting for each of the lines and column data lables, just turn on the customize series, however small values are not visible, a possible workaround is to:

 

  • Turn off data labels
  • Create 6 cards and make use of filters to choose the Sales or Number of Ref and each of the 3 measures
  • Format the cards without any background and small size letter
  • Place it on top of the bars

Untitled.png

Inconvinient on this is that if the size of the bars changes the values will remain on the same place so probably you will get value away from the bars.

 

Another way is to create a table and place it on bottom of the chart.


Regards

Miguel Félix


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

Proud to be a Super User!

Check out my blog:

Power BI em Português





View solution in original post

21 REPLIES 21
Highlighted
Super User III
Super User III

Re: stacked and clustered column (basics)

Hi  @kaycana ,

 

I don't really understand what you mean by not being abble to achieve a cluster and stacked chart in PBI. You can use some work arounds to being abble to achieve it however that depends on your data and the setup.

 

Can you share some example of your data and expected outcome?


Regards

Miguel Félix


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

Proud to be a Super User!

Check out my blog:

Power BI em Português





Highlighted
Helper I
Helper I

Re: stacked and clustered column (basics)

Hola Miguel Felix

thanks for your support. I think this is a beginners problem... 😛

The expected outcome is the graph I put on my initial message.. I need to arrive to show those 2 columns as I do in excel: 1st column shows the % of references within each classification (A) Sum(#Top 30)/total #Ref, B)sum(#rest A)/Total#Ref & C) Sum(#All others)/total#Ref)  and 2nd column also the % of sales within same classification (A) Sum( sales(top30/Total Month Sales, B) sum(sales(rest A)/Total Month Sales & C) Sum(sales(All Others)/Total Month Sales.

My filters are set already for a specific month.

an example of my data currently loaded is:

excel Dso.JPG

 

and the wrongly graph produced in Power Bi is:


wrong.JPG

 

thanks again in advance

 

Highlighted
Community Support
Community Support

Re: stacked and clustered column (basics)

Hi @kaycana 

 

you might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive for business and share the link to the file. Please do not forget to describe the expected results based on this sample data.

 

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
Highlighted
Super User III
Super User III

Re: stacked and clustered column (basics)

Hi @kaycana 

 

Your information is calculated based on total values correct? In your example you only have values for the top30 are you abble to give some sample with the full data for all levels?


Regards

Miguel Félix


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

Proud to be a Super User!

Check out my blog:

Power BI em Português





Highlighted
Helper I
Helper I

Re: stacked and clustered column (basics)

hello @MFelix @v-diye-msft 

I tried to upload the excel here but I dont find an option here how to do it ...

clueless on how to forward you the pbx file i created 

thanks for letting me know.... 

Highlighted
Helper I
Helper I

Re: stacked and clustered column (basics)


Sorry guys 

here below the excel file (modified for security) I used for calculating above measures and graphs.

https://drive.google.com/file/d/1UANLagy02o3VUlXaQmW45kX8yt3WDa3G/view?usp=sharing

thanks to let me know if the shared file works...

 

Highlighted
Super User III
Super User III

Re: stacked and clustered column (basics)

Hi @kaycana m,

 

You need to upload a onedrive, google drive or wetransfer type of web url to share files.


Regards

Miguel Félix


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

Proud to be a Super User!

Check out my blog:

Power BI em Português





Highlighted
Super User III
Super User III

Re: stacked and clustered column (basics)

Hi @kaycana ,

 

It's asking for a password. can you share public


Regards

Miguel Félix


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

Proud to be a Super User!

Check out my blog:

Power BI em Português





Highlighted
Helper I
Helper I

Re: stacked and clustered column (basics)

hi again

I changed the rights so everone can edit it.. hope is ok now...

https://drive.google.com/file/d/1UANLagy02o3VUlXaQmW45kX8yt3WDa3G/view?usp=sharing

 

Helpful resources

Announcements
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Kudoed Authors