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
Anonymous
Not applicable

Line and column chart - too many line values

Hi all!

 

I've got a graph in which I put a line value in. As you can see, it spams the chart with 80, 80, 80. This is completely unecessary, and I am hoping for advice on how to solve this. 

I know I can hide the numbers, so is there a way to rename the DYNAMIC column as a measure, so that is named "Target: <dynamic number>"? I'd like the number to be visible once in the graph, and then the audience would just know what the line meant. 

 

Preben_0-1598912991741.png

 

1 ACCEPTED SOLUTION

@Anonymous Sorry, somehow I missed that. Well, if you go to the Data Labels section, you can turn it off if you use Customize series. Then mabye create create a card visual that put the AVERAGE of that column in there and put it close to the line essentially. That's probably about as good as you are going to get I think.


@ 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!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

4 REPLIES 4
Greg_Deckler
Super User
Super User

@Anonymous - Maybe create a measure like Measure = 80 and then use that as your line value?


@ 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!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

@Greg_Deckler , that will not be very dynamic though 😅 

 

Like I wrote, it has to be dynamic. 
I have a table as such:

 

Date

Target

01.01.2020

80 

01.02.2020

85 

 

Is there a way to make a measure that takes the value of the column Target as it's own name?

 

This PBI thread  from 2017 says it can't be done, but I was hoping after 3 years we could. 

@Anonymous Sorry, somehow I missed that. Well, if you go to the Data Labels section, you can turn it off if you use Customize series. Then mabye create create a card visual that put the AVERAGE of that column in there and put it close to the line essentially. That's probably about as good as you are going to get I think.


@ 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!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

Primitive, but it will do the trick. Cheers!

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.