Forum Discussion
xiumi_hou
Post Partisan
Post PartisanWhat is this visual name?
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?
2 Replies
- VahidDM
Super User
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' colorIf this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
