What is this visual name?

[xiumi_hou]

Hi everyone,

Do someone know the below visual name? How to make the target line separate from each month, and different color compare to the target?

[xiumi_hou]

@VahidDM  Thank you! Do you know how to add the top actual |target? below is title?

[VahidDM]

Hey @xiumi_hou 

You can create this using Line and clustered column chart and add yout target as Line y-Axis
The column that has Bu Support and Enablement as small multiples then set the line setting as this:

• Visual
• Line
• Stroke with = 0
• Markers = On
• Marker Shape = -
• Marker size = 20

To change the column colors dynamic, createa measure like this:

Color Measure =

IF(SUM('Table'[Value])>SUM('Table'[Target]),1,0)

and use that in the conditional formatting of the columns' color

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

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube