Small Multiples chart

[RyanThorsen]

How can I get rid of blank values in a bar chart. I used small multiples and this is what I get

But I want this 

[RyanThorsen]

A matric or table view wouldn't give me the bars though right? I need the bars. Here is some dummy data with the same set-up as my actual data. 

Territory	Region	Score
A	1	84
A	2	91
A	3	85
A	4	86
A	5	82
A	6	84
A	7	81
A	8	92
B	9	75
B	10	83
B	11	86
B	12	84
B	13	87
B	14	80
B	15	79

[lbendlin]

Like this?

[RyanThorsen]

Thanks, that worked to get me the view, but last thing, can I adjust bar colors based on a column. Particularly the Region color in this dummy data?

[lbendlin]

Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

[RyanThorsen]

The smaple data does fully cover what i'm trying to do. with that sample data i was able to build this visual in Tableau. I'd like to get the same viz in Power BI

[lbendlin]

Ah so you want random colors? Why?

[RyanThorsen]

becasue next to this chart I have a map view and the 1,2,3, etc. are mapped to certain regions/states. So I want users to be able to look at the map view and see ok yellow here is region 4 and that yellow maps over to the bar chart 

[lbendlin]

[RyanThorsen]

I matched the y-axis, x-axis, and legend to yours but my viz keeps looking like this, what am i missing?

[lbendlin · Accepted solution]

Expand the Territory/Region hierarchy.

[lbendlin]

Not sure if the "independent y axis"  setting is available for your type of visual.

Have you considered using a regular table or matrix visual and some SVG?

Have some sample data?