Conditional formatting

[anonymus]

Hello ,
I am new to power bi and i am trying to get the average of the trainings based on the countries with the condition given to respective status of each quater. For example in the below screenshot has the example of two contries. suppose if we are taking 10 contries and want to have the average of all the trainings based on the training status values (On track, In progress,NA,Not started  )and build it in a dashboard, how we can achieve that.Please need some suggestions.
thank you

[anonymus]

Thank you

[v-jingzhang · Accepted solution]

Hi @anonymus 

To achieve what you want, you need to separate the process into two steps. First, combine data of all countries into a single table with Power Query. Second, add data into a table or matrix visual and set up conditional formatting for the visual.

In the first step, if every country data is in a single table, so you have 10 tables in total. You need to import all of them into Power BI, then use Append Queries feature to combine all of them into one big table. You need to add a Country column to every table before appending, which can tell you each row represents data from which country table. Append queries - Power Query | Microsoft Learn If your data is from multiple files, you can use the Folder connector to connect to the folder where files are and combine all files easily. Combine files overview - Power Query | Microsoft Learn

After appending, you will have a big table similar to below. Apply the data to Power BI Desktop. 

Then add a matrix visual to the report. Add columns to the visual and set the conditional formatting rule similar to below. 

You will have the result you want. I have attached a sample file at bottom for your reference. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.