topic Re: Small Multiples chart in Custom Visuals Development Discussion

Small Multiples chart

RyanThorsen — Thu, 05 Sep 2024 20:55:00 GMT

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

Re: Small Multiples chart

lbendlin — Fri, 06 Sep 2024 00:10:43 GMT

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?

Re: Small Multiples chart

RyanThorsen — Fri, 06 Sep 2024 13:11:51 GMT

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

Re: Small Multiples chart

lbendlin — Fri, 06 Sep 2024 13:22:40 GMT

Like this?

Re: Small Multiples chart

RyanThorsen — Fri, 06 Sep 2024 14:48:25 GMT

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?

Re: Small Multiples chart

lbendlin — Fri, 06 Sep 2024 15:02:44 GMT

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

Re: Small Multiples chart

RyanThorsen — Fri, 06 Sep 2024 15:38:42 GMT

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

Re: Small Multiples chart

lbendlin — Fri, 06 Sep 2024 16:08:27 GMT

Ah so you want random colors? Why?

Re: Small Multiples chart

RyanThorsen — Fri, 06 Sep 2024 17:37:18 GMT

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

Re: Small Multiples chart

lbendlin — Fri, 06 Sep 2024 17:47:37 GMT

Re: Small Multiples chart

RyanThorsen — Fri, 06 Sep 2024 19:40:37 GMT

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

Re: Small Multiples chart

lbendlin — Fri, 06 Sep 2024 19:47:44 GMT

Expand the Territory/Region hierarchy.