Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
User | Count |
---|---|
51 | |
51 | |
20 | |
17 | |
16 |
User | Count |
---|---|
112 | |
52 | |
42 | |
26 | |
22 |