Forum Discussion

javedbh's avatar
javedbh
Helper II
9 years ago

Condition formatting in Table visual based on Two measures

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.

Need Help
Show and Tell

1 Reply

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    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