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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.