Forum Discussion

Adrianna's avatar
Adrianna
Regular Visitor
8 years ago
Solved

Two data types in one column

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's avatar
    v-juanli-msft
    8 years ago

    Hi Adrianna

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

     

    Best Regards

    Maggie

3 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    8 years ago

    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's avatar
      Adrianna
      Regular Visitor
      8 years ago

      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's avatar
        v-juanli-msft
        Community Support
        8 years ago

        Hi Adrianna

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

         

        Best Regards

        Maggie