Three colums?

[Anonymous]

Hello everybody. I hope you are very well!

I have a Table with 3 columns identifying saving, Cost Avoidance and Efforts required for a project (everything in $). My boss asks me if a visualization like this can be done:

 

I have told him I see it difficult because of the data structure. Does anyone know how to solve this? Thanks a lot!

Chema Ortega

[v-hashadapu]

Hi @Anonymous , Hope you're doing okay! May we know if it worked for you, or are you still experiencing difficulties? Let us know — your feedback can really help others in the same situation.

[v-hashadapu]

Hi @Anonymous , Thank you for reaching out to the Microsoft Community Forum.

We find the answer shared by @danextian  is appropriate. Can you please confirm if the solution worked for you. It will help others with similar issues find the answer easily. It it didn't work, then as suggested by @FBergamaschi , share all the relevant details along with sample data for us to help solve your isse.

Thank you @FBergamaschi & @danextian  for your valuable response.

[v-hashadapu]

Hi @Anonymous , hope you are doing great. May we know if your issue is solved or if you are still experiencing difficulties. Please share the details as it will help the community, especially others with similar issues.

[danextian · Accepted solution]

hi @Anonymous 

Use SVG or  the native stacked bar chart.  You can ask AI to generate a DAX SVG code but this will require several trials and errors. 

Please see the attached pbix.

[FBergamaschi]

Please include, in a usable format, not an image, a small set of rows for each of the tables involved in your request and show the data model in a picture, so that we can import the tables in Power BI and reproduce the data model. The subset of rows you provide, even is just a subset of the original tables, must cover your issue or question completely. Alternatively, you can share your .pbix via some cloud service and paste the link here. Do not include sensitive information and do not include anything that is unrelated to the issue or question. Please show the expected outcome based on the sample data you provided and make sure, in case you show a Power BI visual, to clarify the columns used in the grouping sections of the visual.

Need help uploading data? click here

Want faster answers? click here