How do I set the correct colour in the decomposition tree?
Hello, I have a question regarding the colour in a decomposition tree. I would like to create a KPI tree that should show me in colour whether I have reached the target (bar should be green) or not (bar should be red). I have created an extra variable for this, which looks like this: Color = VAR SumValue = LOG_Kosten_nach_Produkten[Gesamtkosten] VAR Target = LOG_Kosten_nach_Produkten[TargetValue] RETURN SWITCH( TRUE(), SumValue > Target, "Red", SumValue < Target, "Green", SumValue = Target, "Yellow" ) Now I have taken the field value from the variable Color for the colour in my tree. (Analysis tree -> Conditional formatting -> Colour for data bar -> Field value -> Color) Unfortunately, the correct colour is only ever displayed in the child node (rightmost node). As soon as I expand other nodes, the colour of the parent node changes to the wrong colour. If I now display all relevant variables in a table, the correct colour is displayed , even if I select a specific path in the tree (see picture). What could be the reason that the tree displays the colours in the parent nodes incorrectly? The picture shows again what the problem is. I have selected LOM 2 by double-clicking in the tree. The values "Gesamtkosten" and "TargetValue" are the same, but the colour red is displayed in the tree. In the table above, the values are the same as in the tree (also the same) and the correct colour is displayed (yellow). Why is the colour red displayed in the tree, although the values are the same and according to the logic the colour should be yellow? Thank you for your help.Background clolor
Hi. I have a problem. I have a column that should show different background colors. I can not do this via condition control. I have three columns. One column with Yes and No, one column with dates and a third with Datediff. I have combined the Yes and No column and the Date column into a separate column as in the picture. What I want is that if it says Yes or No and is over -14, it should be unchanged. If it says No and is between -14 to 0, the background should be yellow, if it says No and is more than 0 to Max, the background should be red. How do I fix this?? Thanks // Mattias
Conditional data formatting (color palette)
Hello everyone, I´m traing to format this graph with a lot of information. Of course I will apply some filters to visualize the info with more detail. But at first I want to add a color palette but I don´t want to do it one by one... I tried to add a theme but there isn´t one with more than 10 different color tones. I already did it in Tableau but a can´t do the same in Power BI...Conditional formatting a field based on 5 variables
Hi, I have been challanged with this one and hunted google etc to no avail and looking for some advice: I would like to colour code a name field based on 5 different cells: Thisis an abridged table to make life easy, but I have about 60 names or so... e.g. Name Date Indicator 1 Indicator 2 Indicator 3 Indicator 4 Smith, John 23/3/19 3 1 2 Low, Tony Price, Toby 6/4/19 4 2 1 1 Walk, Janine 1 1 Where values are present, they represent compliance to a requirement. I would like 3 outcomes if possible There is 1 date field and the remainders are numerical fields based on measures. 1. Highlight name Red when 5 variables no values 2. Highlight name Yellow when 1 variable or more is present 3. Highlight name Green when all 5 variables are present cheers
