Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
FlankyPank2___
Frequent Visitor

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

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

2 REPLIES 2
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Thank you so much for your reply!

 

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors