Forum Discussion
Dynamic conditional formatting for Line Chart
Hi All,
I have a requirement where current fiscal year line should always be showing up with solid, thick and dark red line. I am aware that dynamic formatting for Line chart is not possible as of now but is there a workaround? I tried converting it to stacked bar graph and then added dax measure but it works with only 2 columns (x-axis and y-axis) and not with 3rd column in Legend. But I want to display the line chart using Display Month and Fiscal Year (as shown in the first screenshot) and always display the current fiscal year line with solid, thick and dark red line.
Would really appreciate any suggestions or workarounds!
Thanks so much!
Hi Saloni_Gupta
You could adapt the method used in this previous post.
In your case, you would need to set the Group By Columns property of
Fiscal_YeartoFiscal_Year_Flag(or another appropriate column).Then when using
Fiscal_Yearas a legend field, formatting selections in the formatting pane will be linked toFiscal_Year_Flag, and formatting will be preseved based onFiscal_Year_Flag.Are you able to get something like that working?
3 Replies
Hi Saloni_Gupta
You could adapt the method used in this previous post.
In your case, you would need to set the Group By Columns property of
Fiscal_YeartoFiscal_Year_Flag(or another appropriate column).Then when using
Fiscal_Yearas a legend field, formatting selections in the formatting pane will be linked toFiscal_Year_Flag, and formatting will be preseved based onFiscal_Year_Flag.Are you able to get something like that working?
Hi Saloni_Gupta ,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.Regards,
Chaithra.Hi Saloni_Gupta ,
We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.Regards,
Chaithra.
