Skip to main content

    Power BI

    New

    dynamic measure format

    Vote (33) Share
    's profile image

    on 17 Nov 2016 03:05:01

    I have a dimension with several KPI's in order to dynamically pass these KPI's to charts and other visuals. The problem is that some of this indicators/measures, are in currency format, others percentages, others number and I need a way to apply the format dynamically.... something similar to custom format of SSAS Cubes

    Comments (4)
    's profile image Profile Picture

    2654cd36 a64d-47d7-81a4-11867fe8fc4d on 06 Jul 2020 00:18:23

    RE: dynamic measure format

    similar one
    https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32728060-dynamically-set-formatting-for-dynamic-measures

    's profile image Profile Picture

    2ae31de4 ba4f-4454-8e3f-399a73f890da on 05 Jul 2020 23:07:03

    RE: dynamic measure format

    Very important from my point of view. Highly requested by our customer.

    's profile image Profile Picture

    e18056d8 a20a-4d16-b49c-aec37d9aeb68 on 05 Jul 2020 23:02:13

    RE: dynamic measure format

    my customers really want this. they are unhappy to see only 1 format for the $ amounts while they want different format. half of my users are unhappy.

    's profile image Profile Picture

    a952733b dd0a-4d95-8b8a-f53e102e476d on 05 Jul 2020 23:00:30

    RE: dynamic measure format

    We can set the switch to use different text formatting for each result by wrapping each line with a FORMAT function That is a useful workaround, definitely not a full solution.