topic Columns With Multiple Data Types in Power BI in Custom Visuals Development Discussion

Columns With Multiple Data Types in Power BI

Anonymous — Thu, 14 Sep 2023 03:50:44 GMT

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

Re: Columns With Multiple Data Types in Power BI

Anonymous — Thu, 14 Sep 2023 03:50:56 GMT

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

)