Forum Discussion
Matrix Table - Have Many Data Monthly KPI With Many Different Target
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.
Hi INA_2024
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered 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
there are matrices that have no targets
there are matrices that have no targets
its the dummy raw data. there are matrices that have no targets.
