Unable to replicate visual

[jdwalker5]

Hello,

I'm building out a report to replace something that was built in Tableau.  I'm not having any luck replicating one of the visuals in Power BI.  It looks like a combination of a matrix and a stacked bar chart.  Is there a way to create the below visual in Power BI?

[Pragati11 · Accepted solution]

HI @jdwalker5 ,

You can use a Stacked Column Chart with Small Multiples. Something like below:

Thanks,

Pragati

[Pragati11 · Accepted solution]

HI @jdwalker5 ,

You can use a Stacked Column Chart with Small Multiples. Something like below:

Thanks,

Pragati

[jdwalker5]

Thank you Pragati.  I'm getting much closer with the small multiples you suggested.  The issue I'me having now is the chart is displaying store regions that have no values.  the chart is meant to bucket lates by store divisin and store region.  in the tableau example, each bucket only shows the store regions that had lates.  below is what I'm getting.

I need it to only show the regions that had lates instead of all the regions.

FYI, store region is my axis.

[Pragati11 · Accepted solution]

HI @jdwalker5 ,

Not sure I understand this part of your response- "I need it to only show the regions that had lates instead of all the regions."

Can you please add more details?

Also, if possible try sharing some sample data in the form a file. Make sure to remove any sensitive infromation from your sample data. You can upload a file to dropbox and share the link here.

Thanks,

Pragati

[jdwalker5]

I got it to work but had to limit the small multiples to specific divisions and then group the visuals together.

It works but feels a little clunky lol.  I appreciate your help, Pragati!

[Pragati11]

Hi @jdwalker5 ,

Can you mark the right response as the Solution to this thread? This will just help others in finding the solutions in a better way.

Thanks,

Pragati