Forum Discussion
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 tab...
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()
)
)