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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
baneworth
Helper II
Helper II

Help with Line value change, but keep same position of Line

Dear All,

 

facing a problem with Line value in Line & stacked column chart.

 

Problem:

currently blue bar and orange line aligned with blue bar are showing same value (using same measure)

i want to exchange orange line value with different value (already have measure for the value -> precentage value)

 

for understanding, blue bar value is actual modules(count)

the other value i want to show on same line is % between Max (grey) to actual

 

line value.png

 

Is it possible to show a different value on same position?

Currently if i just put % easure onto line its way off and not aligned with blue bar

 

 

Best regards

Mat

4 REPLIES 4
amitchandak
Super User
Super User

@baneworth , In case you use % line, it will automatically take the position. So you will not be able to control the position. Power bi does not give an option for the label to be a different measure, as of now.

The max you can do is move % to secondary axis

@amitchandak 

 

Thank you for your answer.

 

I understand that i can use secondary axis, but due to max modules not able to align with 100% it will always look off.

 

line value.2.png

 

Is there no way to exchange the shown value from measure with another one?

 

Best regards

@baneworth , The only option, I can see option - align 0. I doubt I have seen the option that you want.

Let us check with other superusers

@ImkeF , any options like that

 

Dear @amitchandak 

 

I tried around a lot and thought of other ways to solve this problem

 

Do you know if i can somehow show the % value on the shared axis? Measures can't be added right?

Screen below: i added a table below to show what i want to achieve with shared axis.

 

shared axis.png

 

Best reards

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

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.