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. I would like to do this when you hover over the line, if it is possible. 

 

Any help would be greatly appreciated.

 

Jelle

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

  • 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

9 Replies

  • 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

     

    • Jelle's avatar
      Jelle
      Frequent Visitor

      Thanks mehaboob557

       

       

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

      • mehaboob557's avatar
        mehaboob557
        Resolver III

        Hi Jelle,

         

        write the output how u want.

         

        I am guessing like,

         

        22000  --> 22K 

         

        is this what u want?