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

    Bar Chart not showing correct Number Format

    Hannah Cozad


      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?