10 Replies Latest reply: Jan 25, 2017 1:57 PM by Hannah Lines RSS

    Bar Chart not showing correct Number Format

    Hannah Lines

      Hello,

      I have a bar chart with the below expression for measures. Basically, I want to display the values on the bar chart as "$1.23 M" or if the value is less than one million, it should display as "$4.56 K".

       

      IF(<expression>/1000000 <=1,

        Num(<expression>/1000,'$ #,##0.0 K'),

        Num(<expression>/1000000,'$ #,##0.0 M')

      )

       

      When I put the same expression into a table, it displays the correct number format. When I have the expression in the bar chart, is just shows as "1.23". Any ideas as to why the bar chart doesn't reflect the correct number format?

       

      images1.jpg

      Thanks!