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

View all the Fabric Data Days sessions on demand. View schedule

Reply
CLBausch
New Member

Conditional Formatting on drill down works on desktop but not published report

I have a Power BI report with a Clustered Column Chart that displays percent to quota performance by products.

 

The user can drill through the product hierarchy to greater levelds of granularity.

 

The bar graph is conditional formatted red yellow green for performance.

 

On the desktop the conditional formatting works on all levels of drill though

 

On the report published to the web only the top level of the hierarchy conditional formats.  On drill down the bars just display blue regardless of value

2 REPLIES 2
v-sihou-msft
Microsoft Employee
Microsoft Employee

@CLBausch

 

I haven't reproduced your issue. If I set the diverging colors in cluster column chart, it can be rendered properly when I drill down to lower level.

 

36.PNG

 

37.PNG

 

Please check if your hierarchy is built properly and verify your setting on chart. If you still have any question, please share your screenshot.

 

Regards,

Simon Hou

 

Here are screenshots.  First red yellow green is the top of the hierarchy.  Second shot is drilling into EAS region to EEE and EEW district.  Notice formatting is lost.  Third shot is drilling down a level in the hierarchy from Regions to all districts and formatting is maintained EEE and EEW are formatted as desired. Fourth shot is desktop drill in where fomatting is maintained on drill in from Region to district.  Formatting is only lost on published view of report.  Have refreshed several times

 

Top of geo.pngDrill in.pngdrill down.pngDesktop Drill In.png

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