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 

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