Skip to main content

    Power BI

    Needs Votes

    Option to FORMAT () values as numbers (not strings)

    Vote (260) Share
    Clara's profile image

    Clara on 06 Nov 2018 20:57:37

    The FORMAT () function should be extremely flexible for conditionally formatting measures based on slicers and so on. But right now not even chart visuals agree with it. Please fix it? Pretty please?

    Comments (24)
    Clara's profile image Profile Picture

    a3b4892f b2e4-ea11-a813-000d3a8ddfb2 on 22 Aug 2020 20:04:51

    RE: Option to FORMAT () values as numbers (not strings)

    Hi all!
    In this article you can find some workaround to make your numbers formatted in dynamic way:
    https://rollingaverage.com/set-up-measure-selection-with-dynamic-formatting-in-powerbi/

    Clara's profile image Profile Picture

    0a67c001 66d6-ea11-a813-000d3a579c34 on 04 Aug 2020 15:21:48

    RE: Option to FORMAT () values as numbers (not strings)

    Please add this feature. We need it ASAP. Thanks!

    Clara's profile image Profile Picture

    57e147bd 59cd-ea11-a812-000d3a563be2 on 24 Jul 2020 03:04:23

    RE: Option to FORMAT () values as numbers (not strings)

    This would be a very helpful feature.

    Clara's profile image Profile Picture

    0df6158f 3118-402b-a6cd-b66b18940702 on 06 Jul 2020 00:18:16

    RE: Option to FORMAT () values as numbers (not strings)

    Have created visuals that allow user to dynamically choose measures to display but need to way to dynamically format the numbers, since some are percentage, decimal, integers, etc.

    Clara's profile image Profile Picture

    a3309361 99be-ea11-a812-000d3a8ddfb2 on 06 Jul 2020 00:16:24

    RE: Option to FORMAT () values as numbers (not strings)

    Please add it, we need it asap

    Clara's profile image Profile Picture

    ffc95a18 077c-4f05-875f-9b46c01a75f0 on 06 Jul 2020 00:16:02

    RE: Option to FORMAT () values as numbers (not strings)

    I need this to plot a measure trend using the switch functionality to switch between unit types (%, currency, whole number etc). It seems to work ok for tooltips but not plotting on a chart

    Clara's profile image Profile Picture

    d22fc916 cb0a-4f11-ba4f-64048cf11fe7 on 06 Jul 2020 00:15:53

    RE: Option to FORMAT () values as numbers (not strings)

    Would really love this as a feature. Without this, the use of dynamic metrics is limited.

    Clara's profile image Profile Picture

    1c370fc7 a4b0-4356-b936-8b8e7e9be262 on 06 Jul 2020 00:13:49

    RE: Option to FORMAT () values as numbers (not strings)

    By when we can expect this functionality?

    Clara's profile image Profile Picture

    4be21082 e6e6-437e-a8ad-61ff655e8c9e on 06 Jul 2020 00:08:34

    RE: Option to FORMAT () values as numbers (not strings)

    Plase add this function!

    Clara's profile image Profile Picture

    5f20d266 6a28-4919-b589-be8028e71e1e on 06 Jul 2020 00:07:52

    RE: Option to FORMAT () values as numbers (not strings)

    Can't believe this isn't supported already! I want to use a dynamic measure that switches between Sales and Units (using FORMAT to convert between "$#,##0" and "#,##0.00"). The measure works beautifully, but I lose the ability to sort the table because it is now recognized as text!

    Such a basic feature that is desperately needed. Please fix!