How to make constant line dynamic increase every 1 m ?

[admin11]

Hi All

I need to add contact line to my YTD bar chart. how to make the constant line dynamic ?

My PBI file :-

https://www.dropbox.com/s/4yqhwsayztq6rx7/PBT_V2021_400%20SI_TI.pbix?dl=0

Paul

[amitchandak]

@admin11 , create a measure like

measure = month(today()) *1000000

[admin11]

@amitchandak 

Your expression work , but i cannot move to value Box.

[amitchandak]

@admin11 , you can use clustered line visual?

[admin11]

@amitchandak 

The issue now is i cannot create mulitiple colour bar by Column Series. as the Bar become very thin

SEe the below image

[v-easonf-msft · Accepted solution]

Hi， @admin11 

Could you tell me whether your problem have been solved?

For your requirement,you should use 'line and stacked column chart' rather than 'line and clustered column chart'.

Best Regards,
Community Support Team _ Eason

[admin11]

@v-easonf-msft 

Thank you for response to my post . 

Notice that left side the bar chart is my org chart . with out at trend line. 

Right side is the bar chart after add the monthly trend line , it work fine , but the bar become very thin. may question is how to make it thick ?

My PBI file :-

https://www.dropbox.com/s/6or4xh596dmqu94/PBT_V2021_400_SI_TA.pbix?dl=0

Paul

[amitchandak]

@admin11 , In the analytical pane constant line I do not see option to add a measure. So you have use clustered line visual