Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Team,
I have decomposition tree with 3 levels as shown below.
Requirement: In this hierarchy, I would need:
1. All 'Yes' nodes in Blue color
2. Level A node 'No' should be in Black
3. Level B node 'No' should be in Amber
4. Level C node 'No' should be in Grey
Sample pwbix file
https://1drv.ms/u/s!ArRkjWtfVLy-blFLsv39onMwWrQ
Solved! Go to Solution.
Hi @BSM1985 ,
Try to add the following custom measure:
Measure = SWITCH(
TRUE();
SELECTEDVALUE(Testing[A]) = "NO";"Black";
SELECTEDVALUE(Testing[B]) = "NO";"#FFC200";
SELECTEDVALUE(Testing[C]) = "NO";"Grey"
)
You can also change the Black and Grey to other custom colour codes just remember to place the # before the code.
Check PBIX file attach.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsI would like to display on my decomposition tree the "Names" columns with the colors in the "Color" columns respectively.
How can I do that?
I tried with a measure like Switch(True(),Selectvalue(Name1),color) but it doesn't work for me.
Hi @eli9879 ,
Not sure if I understand what you mean by "Names" columns with the colors in the "Color" columns respectively.
Try to create the following measure:
Color Coding = SWITCH(TRUE(),
ISINSCOPE('Table'[Name3]), SELECTEDVALUE('Table'[Color3]),
ISINSCOPE('Table'[Name2]), SELECTEDVALUE('Table'[Color2]),
ISINSCOPE('Table'[Name1]), SELECTEDVALUE('Table'[Color1]))
Be carefull with the order of the columns since the switch function stops at the first result:
See file attach.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsAmazing!! very helpful.
Thanks
Hi @MFelix,
Can you please share how the color of the parent data bars can also be changed as per a condition?
Hi @BSM1985 ,
Try to add the following custom measure:
Measure = SWITCH(
TRUE();
SELECTEDVALUE(Testing[A]) = "NO";"Black";
SELECTEDVALUE(Testing[B]) = "NO";"#FFC200";
SELECTEDVALUE(Testing[C]) = "NO";"Grey"
)
You can also change the Black and Grey to other custom colour codes just remember to place the # before the code.
Check PBIX file attach.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsSorry @MFelix
I was not clear. This works for one node, not for all as shown below. I would need different color for each 'No' for each node as shown in below screenshot.
Hi @BSM1985 ,
Believe that has to do with the order of the function try:
Measure =
SWITCH (
TRUE ();
SELECTEDVALUE ( Testing[C] ) = "NO"; "Grey";
SELECTEDVALUE ( Testing[C] ) = "Yes"; "Blue";
SELECTEDVALUE ( Testing[B] ) = "NO"; "#FFC200";
SELECTEDVALUE ( Testing[B] ) = "Yes"; "Blue";
SELECTEDVALUE ( Testing[A] ) = "No"; "Black";
SELECTEDVALUE ( Testing[A] ) = "Yes"; "Blue"
)
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @MFelix Please take a look on this
In Decomposition tree condition formation i need to change color based on 1 column value .
If it is fail then its parent also should be in red....
You can see the measure i had used in below image ..
Thanks in advance ..
Hi @Ayappan
Can you please share some more details? If you can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |