Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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.
After these steps, you can simply use the legend to group these values.
Regards,
Xiaoxin Sheng
Thank you so much for your reply!
I'll be having a go at this and will let you know the outcome 🙂 Thanks again
User | Count |
---|---|
16 | |
11 | |
5 | |
4 | |
3 |