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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
cladeira
Regular Visitor

Line Chart doesn't work if you need a legend with multiples measures on values


Simple question: in Excel, I can plot on the same Graph a price average and sales quantity. Line Chart can not do the same thing, am I correct? Which visualization object do i need to use?

3 REPLIES 3
Greg_Deckler
Super User
Super User

If you place two or more measures or values in your "Values" area, it automatically creates a legend that allows you to distinguish the multiple lines. If this is not what you are asking, please clarify.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Hi @Greg_Deckler,

 

Let me give show this example. On the same Line Graph, I want to show the sales and price per day. Unfortunately, none of these fields are related to the "Legend". They're actual values.

 

Hope it makes sense now. I think "Dual KPI" Custom Visual.

 

Capture.JPG

 

Thanks,

claudio

I still think the solution I mentioned meets your need. See image. I am at a loss as to how this does not fit the requirement.

 

line.png


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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