Small Multiples Unique Reference Lines

[SWoodring]

I'm building a manufacturing dashboard, and I have a stacked column chart that uses small multiples and draws data from multiple different tables. One of the tables is a capacity table that gives the maximum monthly weight that each manufacturing plant can produce.

The small multiples are able to differentiate the plant capacities in the title of each chart. However, when it comes to adding a reference line, it does not cooperate in the same way. Instead of a unique reference line for each plant, it sums all of the capacities together, and that becomes the reference line for all of the small multiples.

Could this be a problem in my table joins, or is Power BI incapable of showing unique reference lines for each small multiple?

[Anonymous]

Hi @SWoodring 

Currently Power BI does not support separate reference lines for each small multiple, some other users have submitted ideas to Microsoft and you can vote for it hereMicrosoft Idea.

Just an alternative, please consider using separate charts rather than using small multiples.

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@SWoodring seems like an issue with the join, share the details of the relationship to look into it.