cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

Accepted Solutions
Highlighted
Super User II
Super User II

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

@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
Highlighted
Super User II
Super User II

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

@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.






Highlighted
Helper III
Helper III

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

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

Highlighted
Super User II
Super User II

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

@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

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors