Matrix Table - Have Many Data Monthly KPI With Many Different Target

[INA_2024]

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

[Anonymous · Accepted solution]

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 Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[INA_2024]

How about the target <10 ?, I see the icon is still red which should show green.

[Anonymous]

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 Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Ritaf1983]

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  

[INA_2024]

its the dummy raw data. there are matrices that have no targets.

[INA_2024]

there are matrices that have no targets

[INA_2024]

there are matrices that have no targets

[INA_2024]

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

[suparnababu8]

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://curbal.com/curbal-learning-portal/20-tricks-to-finally-master-the-matrix-visualization-in-po...

https://learn.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual