Two data types in one column

[Adrianna]

Hi

I would like to achieve lower presented result. Is there any option to combine nominal and percentage value in one column.  The excel file shows the data properly, in powerbi it is all changed into decimal value. Is there any way to overcome this obstacle?

Thanks a lot and greetings from Poland 🙂

[v-juanli-msft]

Hi @Adrianna

A column must have a single data type.

There is a workaround. Put all data in a single column and write individual measures for each purpose and apply appropriate formatting.

Measure = CALCULATE(MAX([col2]),FILTER(ALL(Sheet1),[col1]="df"))

Best regards

maggie

[Adrianna]

Thank you so much @v-juanli-msft!
Although I would like to express this data in one table so that would look like this:

I want to have various data types within one visualisation - preferably matrix 🙂 Do you think it is possible to solve this problem using numerous measures?

[v-juanli-msft · Accepted solution]

Hi @Adrianna

Unfortunately, i can't find a way to achieve this.I'm afraid it is not possible.

Best Regards

Maggie