Forum Discussion

Jelle's avatar
Jelle
Frequent Visitor
8 years ago
Solved

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...
Need Help
  • mehaboob557's avatar
    mehaboob557
    8 years ago

    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..... :)

  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    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.

    picture1picture2

    Best Regards,
    Angelia

Jelle's avatar
Jelle
Frequent Visitor
8 years ago

Hi mehaboob557,

 

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

mehaboob557's avatar
mehaboob557
Resolver III
8 years ago

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..... :)

  • Jelle's avatar
    Jelle
    Frequent Visitor
    8 years ago

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

    • mehaboob557's avatar
      mehaboob557
      Resolver III
      8 years ago

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

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Microsoft Employee
      8 years ago

      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


    • v-huizhn-msft's avatar
      v-huizhn-msft
      Microsoft Employee
      8 years ago

      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.

      picture1picture2

      Best Regards,
      Angelia