Forum Discussion

Likhitha's avatar
Likhitha
Helper IV
7 years ago

Doubt Regarding Conversions

Hello All,

        I'm having Sales Value,I want to convert that value into Million,Billion And Number by using Slicers.

I'm able to achieve it by using Format Function but as it was text function I'm not able to use in Bar charts.Is there any other way to sort out this??

  

Need Help
Show and Tell
Tips and Tricks

4 Replies

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Likhitha why not you divide your sum with unit based on your selection and change display unit property of y-axis in bar chart to None

    • Likhitha's avatar
      Likhitha
      Helper IV
      7 years ago

      But When I'm trying to concatenate some string to that,its not getting concatenated.