Forum Discussion
Solved
Matrix Table - Have Many Data Monthly KPI With Many Different Target
Im Using Many Diferent Target based matriks table for KPI. I Have Problem with how to make Icons conditional with many diferent target for monthly data. I Use Many Different Target based matrix table...
Hi INA_2024 ,
I made simple samples and you can check the results below:
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
its the raw data, there are matrices that have no targets
| Matriks | Target | Value | Date |
| A | >90 | 100,00 | 01/06/2023 |
| A | >90 | 97,22 | 01/07/2023 |
| A | >90 | 100,00 | 01/08/2023 |
| A | >90 | 100,00 | 01/09/2023 |
| A | >90 | 100,00 | 01/10/2023 |
| A | >90 | 100,00 | 01/11/2023 |
| A | >90 | 99,04 | 01/12/2023 |
| A | >90 | 100,00 | 01/01/2024 |
| A | >90 | 100,00 | 01/02/2024 |
| A | >90 | 100,00 | 01/03/2024 |
| A | >90 | 100,00 | 01/04/2024 |
| A | >90 | 97,56 | 01/05/2024 |
| A | >90 | 100,00 | 01/06/2024 |
| A | >90 | 100,00 | 01/07/2024 |
| A | >90 | 100,00 | 01/08/2024 |
| A | >90 | 100,00 | 01/09/2024 |
| A | >90 | 100,00 | 01/10/2024 |
| B | >90 | 100,00 | 01/06/2023 |
| B | >90 | 100,00 | 01/07/2023 |
| B | >90 | 100,00 | 01/08/2023 |
| B | >90 | 100,00 | 01/09/2023 |
| B | >90 | 100,00 | 01/10/2023 |
| B | >90 | 100,00 | 01/11/2023 |
| B | >90 | 100,00 | 01/12/2023 |
| B | >90 | 100,00 | 01/01/2024 |
| B | >90 | 100,00 | 01/02/2024 |
| B | >90 | 100,00 | 01/03/2024 |
| B | >90 | 100,00 | 01/04/2024 |
| B | >90 | 100,00 | 01/05/2024 |
| B | >90 | 100,00 | 01/06/2024 |
| B | >90 | 100,00 | 01/07/2024 |
| B | >90 | 100,00 | 01/08/2024 |
| B | >90 | 100,00 | 01/09/2024 |
| B | >90 | 100,00 | 01/10/2024 |
| C | >95 | 114,07 | 01/06/2023 |
| C | >95 | 126,53 | 01/07/2023 |
| C | >95 | 84,49 | 01/08/2023 |
| C | >95 | 106,70 | 01/09/2023 |
| C | >95 | 107,78 | 01/10/2023 |
| C | >95 | 100,83 | 01/11/2023 |
| C | >95 | 113,56 | 01/12/2023 |
| C | >95 | 101,78 | 01/01/2024 |
| C | >95 | 90,17 | 01/02/2024 |
| C | >95 | 128,49 | 01/03/2024 |
| C | >95 | 104,29 | 01/04/2024 |
| C | >95 | 97,99 | 01/05/2024 |
| C | >95 | 126,92 | 01/06/2024 |
| C | >95 | 94,43 | 01/07/2024 |
| C | >95 | 92,41 | 01/08/2024 |
| C | >95 | 123,10 | 01/09/2024 |
| C | >95 | 0,26 | 01/10/2024 |
| D | 95,45 | 01/06/2023 | |
| D | 72,45 | 01/07/2023 | |
| D | 57,84 | 01/08/2023 | |
| D | 79,39 | 01/09/2023 | |
| D | 78,77 | 01/10/2023 | |
| D | 71,96 | 01/11/2023 | |
| D | 88,13 | 01/12/2023 | |
| D | 89,53 | 01/01/2024 | |
| D | 71,97 | 01/02/2024 | |
| D | 80,53 | 01/03/2024 | |
| D | 88,65 | 01/04/2024 | |
| D | 75,93 | 01/05/2024 | |
| D | 75,31 | 01/06/2024 | |
| D | 80,46 | 01/07/2024 | |
| D | 84,78 | 01/08/2024 | |
| D | 80,13 | 01/09/2024 | |
| D | 50,00 | 01/10/2024 | |
| E | <10 | 0,85 | 01/06/2023 |
| E | <10 | 0,00 | 01/07/2023 |
| E | <10 | 0,79 | 01/08/2023 |
| E | <10 | 0,00 | 01/09/2023 |
| E | <10 | 0,66 | 01/10/2023 |
| E | <10 | 2,29 | 01/11/2023 |
| E | <10 | 0,00 | 01/12/2023 |
| E | <10 | 0,49 | 01/01/2024 |
| E | <10 | 0,00 | 01/02/2024 |
| E | <10 | 0,62 | 01/03/2024 |
| E | <10 | 0,65 | 01/04/2024 |
| E | <10 | 0,00 | 01/05/2024 |
| E | <10 | 0,00 | 01/06/2024 |
| E | <10 | 0,00 | 01/07/2024 |
| E | <10 | 0,00 | 01/08/2024 |
| E | <10 | 0,00 | 01/09/2024 |
| E | <10 | 0,00 | 01/10/2024 |
Hi INA_2024
I thin you can use conditional formatting option to highlight specific data points. Need addititonal info Pls go through the below urls
https://learn.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual