topic Re: Creating a Key for Trend line / Static Line / Average Line in Developer

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

FlankyPank2___ — Wed, 05 Apr 2023 21:20:00 GMT

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

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

Anonymous — Fri, 07 Apr 2023 02:16:36 GMT

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.com)

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

Regards,

Xiaoxin Sheng

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

FlankyPank2___ — Tue, 11 Apr 2023 09:50:06 GMT

Thank you so much for your reply!

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