How to create bar chart and stacked bar chart in a single powebi desktop chart

[Koushik0206]

I've a data with below structure, On-hand inventory is coming from a different table and I've this as a measure.  How to create the intended visual? Please help, thanks!

[v-pnaroju-msft]

Hi @Koushik0206,

Thankyou for the update.

We are pleased to learn that you have identified a workaround and successfully resolved the issue. Kindly share the details of the workaround and mark the response that addressed your query as the accepted solution. This will help other community members facing similar challenges to find solutions more efficiently.

Please continue to use the Fabric Community for any further assistance with your queries.

Thank you.

[v-pnaroju-msft]

Hi Koushik0206,

We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.

If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.

Thank you.

[Koushik0206]

Hi v-pnaroju-msft,

Thanks for your response. This is not exactly what I was looking for as for a single SKU I wanted the the bar charts for each metric similar to the visual. But I have already found a workaround by using two separate charts so never mind putting more effort into it. Thank you so much for your response! 😍

[v-pnaroju-msft · Accepted solution]

Thankyou, @BhavinVyas3003, for your response.

Hi @Koushik0206,

Thank you for your inquiry on the Microsoft Fabric Community Forum.

Please find attached the screenshot and the PBIX file, which may assist in resolving the issue:

If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will help other community members who face similar queries.

Thank you.

[Koushik0206]

Hi everyone, this query is not resolved yet. Appreaciate your quick support on this, thanks!

[BhavinVyas3003]

Use a stacked bar chart visual.

Add SKU to the Axis.

Add the following measures to Values:

• Safety Stock
• Cycle Stock
• Difference = On-hand Inventory − (Safety + Cycle)

To show On-hand Inventory as a full bar, stack all parts so they sum to the On-hand value.

[Koushik0206]

This does not work or may be I was not clear enough in explaining. 

• In stacked bar chart there is no "Values" option to drag the measures It only has X-Axis, Y-Axis, Legend and Small Multiples
• If I drag the Safety Stock, Cycle Stock and Difference measures it always stacks on top and in this way there will always be a single bar/ stacked bar

Some of the main issues I'm thinking of, let me know the workaround or if any better approach is available

• We cannot have bar chart and stacked bar chart in a single chart
• The intended visual looks close to waterfall but waterfall chart also does not allow stacking (I think)
• Since both safety and cycle stocks are measures, we don't have anything to bifurcate these two (e.g. as legends) in single bar

Please help!