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