Forum Discussion

Anonymous

Not applicable

2 years ago

Solved

Matrix Conditional formating based on row value

Hello everybody, I have a matrix table where: Rows shows different business process of the company Columns shows the availability of that process for each month Values: meausure of the availabil...

Need Help

Anonymous

2 years ago

Hi Anonymous ,

I noticed that the data type of [Availab.] is the decimal number.

99.98 converted to percentage format is 9980%

I edited the measure and checked to see if this was causing the problem.

Availab. Monthly_Color = SWITCH(
    MAX('Incidents Analysis'[Bussiness Process]),
    "BUSINESS PROCESS A",IF([Availab. Monthly]<99.7,"red"),
    "BUSINESS PROCESS B",IF([Availab. Monthly]<99.7,"red"),
    "BUSINESS PROCESS C",IF([Availab. Monthly]<99.8,"red"),
    "BUSINESS PROCESS D",IF([Availab. Monthly]<99.5,"red"),
    "BUSINESS PROCESS E",IF([Availab. Monthly]<99.8,"red"),
    "BUSINESS PROCESS F",IF([Availab. Monthly]<99.7,"red"),
    "BUSINESS PROCESS G",IF([Availab. Monthly]<99.8,"red"),
    "BUSINESS PROCESS H",IF([Availab. Monthly]<99.8,"red"),
    "BUSINESS PROCESS I",IF([Availab. Monthly]<99.9,"red"),
    "BUSINESS PROCESS J",IF([Availab. Monthly]<99.8,"red"),
    "BUSINESS PROCESS K",IF([Availab. Monthly]<99.5,"red"),
    "BUSINESS PROCESS L",IF([Availab. Monthly]<99.5,"red"),
    "BUSINESS PROCESS M",IF([Availab. Monthly]<99.5,"red")
)

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data in the Power BI Forum

demo.pbix27 KB

Anonymous

Not applicable

2 years ago

Hi Anonymous ,

I'm not sure.
Is there no value in this row? What is your modified measure?

It would be helpful to consider providing a file that does not contain private data.

Best Regards,
Gao
Community Support Team

How to get your questions answered quickly -- How to provide sample data in the Power BI Forum

Anonymous

Not applicable

2 years ago

@Hi Anonymous

Please find below the meausure.

Availab. Monthly_Color = SWITCH(
    MAX('Incidents Analysis'[Bussiness Process]),
    "BUSINESS PROCESS_A",IF([Availab. Monthly]<0.997,"red"),
    "BUSINESS PROCESS_B",IF([Availab. Monthly]<0.997,"red"),
    "BUSINESS PROCESS_C",IF([Availab. Monthly]<0.998,"red"),
    "BUSINESS PROCESS_D",IF([Availab. Monthly]< 0.995,"red"),
    "BUSINESS PROCESS_E",IF([Availab. Monthly]<0.998,"red"),
    "BUSINESS PROCESS_F",IF([Availab. Monthly]<0.997,"red"),
    "BUSINESS PROCESS_G",IF([Availab. Monthly]< 0.998,"red"),
    "BUSINESS PROCESS_H",IF([Availab. Monthly]< 0.998,"red"),
    "BUSINESS PROCESS_I",IF([Availab. Monthly]<0.999,"red"),
    "BUSINESS PROCESS_J",IF([Availab. Monthly]<0.998,"red"),
    "BUSINESS PROCESS_K",IF([Availab. Monthly]<0.995,"red"),
    "BUSINESS PROCESS_L",IF([Availab. Monthly]< 0.995,"red"),
    "BUSINESS PROCESS_M",IF([Availab. Monthly]< 0.995,"red")
)

The problem only appears with the Row "Business Process F".

Incident	Opened date	Bussiness Process	SLA Impact sg	Year	Week	Month	Day	Impacted Time	Availab.
INC000001543806	10/10/2023	BUSINESS PROCESS A	410	2023	42	10	10/10	0:06:50	99,98%
INC000001543806	10/10/2023	BUSINESS PROCESS C	335	2023	42	10	10/10	0:05:35	99,99%
INC000001543152	10/10/2023	BUSINESS PROCESS M	3120	2023	42	10	10/10	0:52:00	99,88%
INC000001543152	10/10/2023	BUSINESS PROCESS K	3120	2023	42	10	10/10	0:52:00	99,88%
INC000001543665	10/10/2023	BUSINESS PROCESS B	840	2023	42	10	10/10	0:14:00	99,97%
INC000001543383	09/10/2023	BUSINESS PROCESS A	14400	2023	42	10	10/9	4:00:00	99,44%
INC000001543688	09/10/2023	BUSINESS PROCESS C	1200	2023	42	10	10/9	0:20:00	99,95%
INC000001540831	03/10/2023	BUSINESS PROCESS A	10800	2023	41	10	10/3	3:00:00	99,58%
INC000001540020	29/09/2023	BUSINESS PROCESS C	17100	2023	40	9	9/29	4:45:00	99,34%
INC000001540020	29/09/2023	BUSINESS PROCESS A	12600	2023	40	9	9/29	3:30:00	99,51%
INC000001539379	29/09/2023	BUSINESS PROCESS F	2400	2023	40	9	9/29	0:40:00	99,91%
INC000001539379	29/09/2023	BUSINESS PROCESS H	2400	2023	40	9	9/29	0:40:00	99,91%
INC000001538799	28/09/2023	BUSINESS PROCESS F	0	2023	40	9	9/28	0:00:00	100,00%
INC000001537420	25/09/2023	BUSINESS PROCESS A	900	2023	40	9	9/25	0:15:00	99,97%
INC000001537139	25/09/2023	BUSINESS PROCESS C	34200	2023	40	9	9/25	9:30:00	98,68%
INC000001537139	25/09/2023	BUSINESS PROCESS A	34200	2023	40	9	9/25	9:30:00	98,68%
INC000001536168	22/09/2023	BUSINESS PROCESS F	11700	2023	39	9	9/22	3:15:00	99,55%
INC000001536168	22/09/2023	BUSINESS PROCESS H	11700	2023	39	9	9/22	3:15:00	99,55%
INC000001533830	22/09/2023	BUSINESS PROCESS K	8100	2023	39	9	9/22	2:15:00	99,69%
INC000001533830	22/09/2023	BUSINESS PROCESS M	8100	2023	39	9	9/22	2:15:00	99,69%
INC000001533550	21/09/2023	BUSINESS PROCESS M	9000	2023	39	9	9/21	2:30:00	99,65%
INC000001533550	21/09/2023	BUSINESS PROCESS K	9000	2023	39	9	9/21	2:30:00	99,65%
INC000001529754	08/09/2023	BUSINESS PROCESS C	6300	2023	37	9	9/8	1:45:00	99,76%
INC000001529754	08/09/2023	BUSINESS PROCESS C	12600	2023	37	9	9/8	3:30:00	99,51%

Thanks.

Anonymous
Not applicable
2 years ago
Hi Anonymous ,

I noticed that the data type of [Availab.] is the decimal number.

99.98 converted to percentage format is 9980%

I edited the measure and checked to see if this was causing the problem.

Availab. Monthly_Color = SWITCH( MAX('Incidents Analysis'[Bussiness Process]), "BUSINESS PROCESS A",IF([Availab. Monthly]<99.7,"red"), "BUSINESS PROCESS B",IF([Availab. Monthly]<99.7,"red"), "BUSINESS PROCESS C",IF([Availab. Monthly]<99.8,"red"), "BUSINESS PROCESS D",IF([Availab. Monthly]<99.5,"red"), "BUSINESS PROCESS E",IF([Availab. Monthly]<99.8,"red"), "BUSINESS PROCESS F",IF([Availab. Monthly]<99.7,"red"), "BUSINESS PROCESS G",IF([Availab. Monthly]<99.8,"red"), "BUSINESS PROCESS H",IF([Availab. Monthly]<99.8,"red"), "BUSINESS PROCESS I",IF([Availab. Monthly]<99.9,"red"), "BUSINESS PROCESS J",IF([Availab. Monthly]<99.8,"red"), "BUSINESS PROCESS K",IF([Availab. Monthly]<99.5,"red"), "BUSINESS PROCESS L",IF([Availab. Monthly]<99.5,"red"), "BUSINESS PROCESS M",IF([Availab. Monthly]<99.5,"red") )

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
demo.pbix27 KB
- Anonymous
  Not applicable
  2 years ago
  Hi Anonymous
  That´s not the problem. It is not related with the data type. it seems that in that particular case,
  BUSINESS PROCESS F",IF([Availab. Monthly]<99.7,"red"),
  
  and for that specific month (March --> Availab. = 99.53) the formula is not working... It is quite strange.
  Any idea?

Forum Discussion

Matrix Conditional formating based on row value

Related content

Matrix Row Conditional Formatting

Conditional Formatting using DAX

Conditional Formatting with Matrix Table

Conditional Formatting

Conditional Formatting