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

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