Creating a Key for Trend line / Static Line / Average Line

[FlankyPank2___]

Hi,

I'm a very new user.  I've created a graph and have added 3 lines.  A Static line to representent KPI, Average line and a trend line.

In some cases the 3 lines are very close together and so I wondered if there was a way to illustrate the lines in a key?  Or if this is bad practice?

I've googled this to no avail.  Thanks for any help 🙂

Thanks Claire

[Anonymous]

Hi @FlankyPank2___,

You can create a new table with three types and use it as legend of the chart, then you can write a measure to check current legend values to redirect to different line expressions.

My Favorite DAX Feature: SELECTEDVALUE with SWITCH | Winston-Salem Power BI User Group (pbiusergroup...

After these steps, you can simply use the legend to group these values.

Regards,

Xiaoxin Sheng

[FlankyPank2___]

Thank you so much for your reply!

I'll be having a go at this and will let you know the outcome 🙂  Thanks again