Condition formatting in Table visual based on Two measures

[javedbh]

Hi Everyone,

I have two measure in Table visual, one [Average Yield for 2016] for current year's yield till date and [Average YTD Yield Last Week] for current year's yield till last week. I want to somehow highlight/format the [Average Yield for 2016] column based on the following formula:

if [Average Yield for 2016] < [Average YTD Yield Last Week] show Red

if [Average Yield for 2016] = [Average YTD Yield Last Week] show Orange

if [Average Yield for 2016] > [Average YTD Yield Last Week] show Green

A sample is created in Excel:

It is not necessary to show these arrows. Changing background color will also work. Please help how can I achieve this or anything similar.

[v-qiuyu-msft]

Hi @javedbh,

As far as I know, indicators like red, yellow, green arrows are not available in Power BI Desktop currently. In your scenario, you can create Power Pivot model and KPIs in Excel, then use Import -> Excel Workbook Contents to import and display KPIs in tables. For more information, please refer to this article: Import and display KPIs.

Best Regards,
Qiuyun Yu