Columns With Multiple Data Types in Power BI

[Anonymous]

Hello,

Currently within my dataset there is a column that contains numerical, text, percentage and currency data types. Is it possible to show them in the same datatype while we select?

The table when loaded it saves it by default as text which is understandable.

For example:

Value
89
150
103
150
$    1,548,550.45
$    2,909,454.99
Phase 0
Phase 0
Phase 0
Phase 0
94%
101%
95%
99%

Excel and Power BI difference.

Thanks for hellping in Advance

Ayush

[Anonymous]

I tried to create a measure but does work as per my requirement:

Measure1 =

VAR SelectedIndicator = SELECTEDVALUE('Sheet1'[Indicator ])

VAR ValueAsText =

    MAXX(

        FILTER('Sheet1', 'Sheet1'[Indicator ] = SelectedIndicator),

        'Sheet1'[Value]

    )

RETURN

IF (

    SelectedIndicator = "FY23 Worked Hours Monthly Actual Percentage",

    FORMAT(VALUE(ValueAsText), "0%"),

    IF (

        SelectedIndicator = "FY23 Net Operating Income Monthly Actual",

        "$" & FORMAT(VALUE(ValueAsText), "#,##0.00"),

        BLANK()

    )

)