Forum Discussion
Zakaria_1980
Post Patron
Post PatronLine stype in the graph
Hello, please I need that the curve in green whenevr it is before the bar chart the type of the line is solid and when it is after the bar chart the type of the line should be a dotted line. beca...
Zakaria_1980Post Patron
Post Patronthe red bar is shifted automatically from week to another based on the actual figures that i got. in the grapg i've shared with you, i got the actuals for W33 which means the red bar is plot automatically in the that week.
what i've asked is only on thu curve in green. in the graph i've sent i made the type of the line in dash. the team want that curve the type of the line should be solid before the red bar and then the type will change in dotted line after the red bar.
AllisonKennedy
Community Champion
Community ChampionZakaria_1980
That picture you drew is exactly what I had in mind after your first post, just need to know what your raw data model looks like and what are you currently using for the values of the green and red lines? Is the red line a MEASURE? is the green line a column or measure?
To make the line change style, you will need to split the line into two MEASURES - so first calculate the green line for everything BEFORE week 33. Make this solid. Then calculate the green line for everything AFTER week 33. Make this dotted.
Does that make sense? Let us know how you get on and if you need more info we will need your specific table and column names and their relationships.
It can change colour at the red line using conditional formatting.
That picture you drew is exactly what I had in mind after your first post, just need to know what your raw data model looks like and what are you currently using for the values of the green and red lines? Is the red line a MEASURE? is the green line a column or measure?
To make the line change style, you will need to split the line into two MEASURES - so first calculate the green line for everything BEFORE week 33. Make this solid. Then calculate the green line for everything AFTER week 33. Make this dotted.
Does that make sense? Let us know how you get on and if you need more info we will need your specific table and column names and their relationships.
It can change colour at the red line using conditional formatting.