Any option to create a table where each cells can be conditional formatted based on different target

[Aravind_Raj]

Hi,

We have a problem trying to recreate a performance matrix which was made in Excel to Power BI. The matrix has cells with values and a colour background which is set based on different conditions set. The matrix has KPI's listed row wise and countries listed column wise. As each combination of KPI and country has a different set of Target, it has become a challenge for us to incorporate the same in Power BI. We understand that this is very simple to perform in excel unlike Power BI.

One of the work around which we have adopted to perform this was by creating cards with states inplace of each cells and defining the value and states based on which the background or text colour changes. However since there are more than 10 KPI's and more than 10 countries to be incorporated we had to create close to 100 cards which had a huge impact over the performance of the report when it was published and shared online. Due to the inclusion of so many cards the report crashes oftenly whenever we tried to open the same in Power BI online. Each cards when alligned in the form of a table looked decent but performance is a concern.

We understand that the above work around is not advisable due to the number of cards used in the same report,however if you have any other ideas to fix this issue and recreate the same in Power BI,it would be of really great help.

We have also tried the table heat map in the custom visual gallery,however we do not have any control over setting the targets in it as we have a specific target for each cells in the table. Same goes with the use of conditional formatting in a table in Power BI.

Please feel free to give your thoughts on other work arounds or improving the performance based on the current method being used(cards with states).

Example -

Thanks & Regards,

Arvind Raj 

[v-qiuyu-msft]

Hi @Aravind_Raj,

You can try the Import Excel Workbook option: Import and display KPIs.

Also you can submit a idea here.

Best Regards,
Qiuyun Yu