Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi Team,
I have decomposition tree with 3 levels as shown below. In this hierarchy, I would need: If one of the nodes unders product is yellow, all of its parent nodes should be yellow in color. Could someone please help on fulfilling this requirement.
Thanks,
SV
Hi @suni_v ,
Based on my test, I'm afraid this is not supported in Power BI.
To my understanding, if the decomposition tree is formatted as what you want, let's take an example:
When Product="Paseo", the bar of MonthNumer=6 should be yellow;
When Product="Velo", the bar of MonthNumer=6 should be purple;
Then how shoud the bar of MonthNumer show? Yellow or Purple?
Therefore, it may not supported.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @suni_v ,
I tried this by creating a measure and use it in conditional formatting,
CF =
SWITCH(TRUE(),
SELECTEDVALUE(financials[Year])=2014,"#FFC200",
SELECTEDVALUE(financials[Year])=2013,"Black")
Try and let me know if it works as per your expectation or not.
Thanks,
Arul
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
10 | |
6 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |