Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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 , create a measure like
measure = month(today()) *1000000
@admin11 , you can use clustered line visual?
The issue now is i cannot create mulitiple colour bar by Column Series. as the Bar become very thin
SEe the below image
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
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
@admin11 , In the analytical pane constant line I do not see option to add a measure. So you have use clustered line visual