Forum Discussion
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 tables for KPIs. I Have a Problem with how to create a conditional Icon with many different targets for monthly data. I want to create the same view as in the picture.
Please help me to create this display with detailed steps using picture.
its the dummy raw data. there are matrices that have no targets
thanks for advance
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.
9 Replies
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
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.
How about the target <10 ?, I see the icon is still red which should show green.
Hi INA_2024 ,
Based on the original context, using this expression:
Measure = SWITCH(TRUE(),CONTAINSSTRING(MAX('Table'[Target]),">")&&MAX('Table'[Value])>MAX('Table'[Text Range]),1, CONTAINSSTRING(MAX('Table'[Target]),"<")&&MAX('Table'[Value])<MAX('Table'[Text Range]),1,0)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.
