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
avulasandeep
Helper III
Helper III

Not able to keep Km/Hr Lable next to measure in axis

 

I need Km/Hr as lable that measure have to keep in AxisI need Km/Hr as lable that measure have to keep in Axis

Hi Everyone ,

here i kept measure  avg speed in x axis and  no of rides in y axis and i need  Km/Hr  as label for avg , 
so
i created measure for that but after creating the measure i am unable to keep in axis .
we have to keep only in tooltip but
i need to  keep only in x axis .

 i need label Km/Hr at end of the measure  ex: 90 Km/Hr

 

 

Thanks 

Sandeep Kumar(avulasandeep19@gmail.com)

9441181581

1 ACCEPTED SOLUTION

@avulasandeep

 

Sandeep, I understand. Try the following:

 

Following your example, say your measure for speed is:

Speed = SUM(table[value])

 

Now create a new measure which looks like this:

 

Speed Km/Hr = [Speed] & " Km/Hr"

 

(NB: leave a 'space' between the first " symbol and the Km/HR text.)

See if that works for you. (Beware though that the result will no longer be a Number/Numeric output, but a text output.)

 

Regards,

 

Paul.





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

3 REPLIES 3
PaulDBrown
Community Champion
Community Champion

@avulasandeep

 

Apologies in advance, but I'm unsure about what exactly you are trying to achieve. Can you explain a little bit more?

Thanks,

 

Paul.





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Hi paul ,

 

just i need  measure with Km/hr  as end . 

Ex :  if we do the following calculation :

sum(speed)  = 60

 so output is 60  but i need "60 Km/Hr "as value  not 60 .

 

Thanks ,

sandeep kumar

9441181581

@avulasandeep

 

Sandeep, I understand. Try the following:

 

Following your example, say your measure for speed is:

Speed = SUM(table[value])

 

Now create a new measure which looks like this:

 

Speed Km/Hr = [Speed] & " Km/Hr"

 

(NB: leave a 'space' between the first " symbol and the Km/HR text.)

See if that works for you. (Beware though that the result will no longer be a Number/Numeric output, but a text output.)

 

Regards,

 

Paul.





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






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.