Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Table with mixed Data Types.

Hi Guys,   I need to replicate a table from Excel into PBI.  The problem is, I have columns that have different Data Types, Decimal and %, I also have rows that have different data types Decimal an...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    HI, Anonymous 

    For conditional formatting on Values, You could drag Column1 in Values, and when do conditional formatting, you could based on anther field

     

    Best Regards,

    Lin

v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

hi, Anonymous 

If you want to show mixed Data Types, It only could be shown as Text format.

You could also FORMAT Function to custom format.

 

Best Regards,

Lin

Anonymous's avatar
Anonymous
Not applicable
7 years ago

hI,

 

That's exactly what I did, I used Format "Percent" and Format Standard for Decimals.  The table works well and shows be what I want.

 

I can't do the conditional formatting bit "Data Type Percentage"  column.

 

Regards

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    hi, Anonymous 

    You could use Format Function to add a mixed Data Types column, and then use basic column for conditional formatting.

     

    Best Regards,
    Lin

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      In the Matrix table, I can only do conditional formatting on Values, but I need conditional formatting on columns, but it doesn't give me the option to.

       

      Or am I missing something.

       

       

      • v-lili6-msft's avatar
        v-lili6-msft
        Community Support
        7 years ago

        HI, Anonymous 

        For conditional formatting on Values, You could drag Column1 in Values, and when do conditional formatting, you could based on anther field

         

        Best Regards,

        Lin