Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
leahschneider
Helper III
Helper III

Color Saturation in Date Hierarchy

I have a clustered column chart with a date hierarchy as the x axis.  I want to be able to have color saturation based on the sum of a column.  This works in the first level of the hierarchy and if I go to the next level.  However, when I try to expand all down one level, everything turns to the default green, even though I can still see different values in the tooltips and in see records.  Is there any way to fix this?

1 ACCEPTED SOLUTION

I'm using the November update.  I turned on then off drill down in the right top coner of the visualization and it works now.  I'm not sure why.

View solution in original post

5 REPLIES 5
Greg_Deckler
Community Champion
Community Champion

What visualization are you using?



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Clustered column chart

Hmm, in my test for this, I did not see this issue. I am on the November version of Power BI Desktop. I was able to see color saturation at all levels. Check that you are on the latest build and if not, update and see if you still have the problem.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

I'm using the November update.  I turned on then off drill down in the right top coner of the visualization and it works now.  I'm not sure why.

Anonymous
Not applicable

@leahschneider @Greg_Deckler,

So I'm able to duplicate the problem on the January 2017 edition of Power BI so I'm wondering if this really is "fixed". I have a hierarchy and a color saturation setup on a simple bar chart. On the top level, the color saturation is there. When I click on the Drill Mode arrow (upper, right-hand side of the viz) and then click on a bar, I descend into the hierarchy and the color changes to the default blue/green. 

 

Now I can click on the double arrows (on the left-hand side of the viz) and the color saturation stays in place all throughout the hierarchy. It seems as though the color saturation only disappears as I click through and descending the hierarchy. 

 

Any thoughts?


Thanks,

Jonathan 

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors