Need different target lines in bar chart with small multiples

[Anonymous]

I'm working on a report where each person in the small multiple is having a different target. The bar chart have 4 months on yaxis and names on small multiples with values in bars. The target will be same for all the 4months but will be different for each person. I tried analytics byt setting up "Constant Line" but it applies to all the names with same value. I also tried some visuals from the store but couln't able to get what I intended to. Suggest a way to achieve the mentioned feature. I'm open to other ideas of visuals to display what i need.

[Anonymous]

Hi  @Anonymous ,

As far as I know, Power BI doesn't support the ability to show different Constant Lines in small multiples at the moment.

You can consider using Line and stacked column chart visual to create a measure to be placed on the Line y-axis for display.

There is an idea about this feature that you can vote for .

Microsoft Idea

You can also submit an idea for it at Home (microsoft.com) and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.

This is the related document, you can view this content:

Dynamic X-Axis Constant line Small Multiples - Microsoft Fabric Community

Solved: Different constant lines in small multiples - Microsoft Fabric Community

Best Regards,

Liu Yang

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