Forum Discussion

Anonymous's avatar
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's avatar
    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

wasirafi's avatar
wasirafi
Helper I
2 years ago

lbendlin  if i want to get another color "green" for values greater than 99.5, i modified the DAX to below

Availab. Monthly_Color = SWITCH(
    MAX('Incidents Analysis'[Bussiness Process]),
    "BUSINESS PROCESS A",IF([Availab. Monthly]<99.7,"red"),
    "BUSINESS PROCESS A",IF([Availab. Monthly]>99.7,"Green")    
)

 However i dont get the green color. what am i doing wrong in this.

lbendlin's avatar
lbendlin
Super User
2 years ago
Availab. Monthly_Color = SWITCH(
    MAX('Incidents Analysis'[Bussiness Process]),
    "BUSINESS PROCESS A",IF([Availab. Monthly]<99.7,"red","Green")    
)