Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Columns With Multiple Data Types in Power BI

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

"Need Help"
Need Urgent Help
Urgent

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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()
        )
    )