Reply
Frequent Visitor
Posts: 6
Registered: ‎12-04-2017
Accepted Solution

Graph Hover Options

Hello,

 

When you hover over the line in a graph, you see the full value. Is it possible to change the way this is shown? With data labels, you can change the display units to thousands for example. I would like to do this when you hover over the line, if it is possible. 

 

Any help would be greatly appreciated.

 

Jelle


Accepted Solutions
Highlighted
Member
Posts: 117
Registered: ‎08-01-2017

Re: Graph Hover Options

Hi @Jelle,

 

Write measures to get the value of each row per category or what ever u want.

 

Suppose,

 

Measure for compare = Measure for compare = CALCULATE(SUMX(your_table_name,your_table_name[amount]), ALLEXCEPT(your_table_name,your_table_name[name]))

 

next measure,

 

Num format =
IF (
[Measure for compare] >= 1000000,
FORMAT ( [Measure for compare], "#,##0,,m" ),
IF (
[Measure for compare] >= 1000,
FORMAT ( [Measure for compare], "#,##0,k" ),
FORMAT ( [Measure for compare], "General Number" )
)
)

 

check and let me know..... Smiley Happy

View solution in original post

Super Contributor
Posts: 3,609
Registered: ‎09-27-2016

Re: Graph Hover Options

[ Edited ]

Hi @Jelle,

After test, another way you can set the display values in thousands, please review the first screenshot, it display the original value of each year, you can choose "thousands"(highlighted in yellow background) on the data label under Format, please see the second screenshot.

1.PNGpicture12.PNGpicture2

Best Regards,
Angelia

View solution in original post


All Replies
Member
Posts: 117
Registered: ‎08-01-2017

Re: Graph Hover Options

Hi @Jelle,

 

use the below graph visual as shown below and put the values in line values. Then goto y-axis under that display dropdown. select what ever you wanna display like thousands, auto, e.t.c

 

graph.PNGgraphsq.PNG

Frequent Visitor
Posts: 6
Registered: ‎12-04-2017

Re: Graph Hover Options

Thanks @mehaboob557

 

Tijdelijk (dit mag verwijderd worden zodra iemand dit ziet).PNG

 

I was trying to change this, I should have added a picture the first time. Is is possible to show those numbers in thousands?

Member
Posts: 117
Registered: ‎08-01-2017

Re: Graph Hover Options

Hi @Jelle,

 

write the output how u want.

 

I am guessing like,

 

22000  --> 22K 

 

is this what u want?

Frequent Visitor
Posts: 6
Registered: ‎12-04-2017

Re: Graph Hover Options

Hi @mehaboob557,

 

That's right, sorry for not being more clear. 

Highlighted
Member
Posts: 117
Registered: ‎08-01-2017

Re: Graph Hover Options

Hi @Jelle,

 

Write measures to get the value of each row per category or what ever u want.

 

Suppose,

 

Measure for compare = Measure for compare = CALCULATE(SUMX(your_table_name,your_table_name[amount]), ALLEXCEPT(your_table_name,your_table_name[name]))

 

next measure,

 

Num format =
IF (
[Measure for compare] >= 1000000,
FORMAT ( [Measure for compare], "#,##0,,m" ),
IF (
[Measure for compare] >= 1000,
FORMAT ( [Measure for compare], "#,##0,k" ),
FORMAT ( [Measure for compare], "General Number" )
)
)

 

check and let me know..... Smiley Happy

Frequent Visitor
Posts: 6
Registered: ‎12-04-2017

Re: Graph Hover Options

Thank you very much for helping @mehaboob557. I will try this and report back later!

Member
Posts: 117
Registered: ‎08-01-2017

Re: Graph Hover Options

Ok... If its working fine... Give a kudo and accept the solutions

Super Contributor
Posts: 3,609
Registered: ‎09-27-2016

Re: Graph Hover Options

Hi @Jelle,

Please mark the right reply as answer if you have resolved your issue, so more people will get helpful information from here. Thanks for understanding.

Best Regards,
Angelia


Super Contributor
Posts: 3,609
Registered: ‎09-27-2016

Re: Graph Hover Options

[ Edited ]

Hi @Jelle,

After test, another way you can set the display values in thousands, please review the first screenshot, it display the original value of each year, you can choose "thousands"(highlighted in yellow background) on the data label under Format, please see the second screenshot.

1.PNGpicture12.PNGpicture2

Best Regards,
Angelia