Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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
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.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
28 | |
26 | |
22 | |
22 | |
18 |
User | Count |
---|---|
52 | |
34 | |
28 | |
24 | |
21 |