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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Axis value color conditional formatting not working

Adding conditional formatting to dynamically format the color of the x- or y-axis labels does not work. In the screenshot below, note that the conditional formatting applied to the Y-Axis of the bar chart should change the axis value color to pink only if the [Total Amount] is greater than 100. However it applies the pink color to all axis values.

 

Here's a link to the PBIX file: https://drive.google.com/file/d/1udNYuZN8OdrUyUTkT_lQsAWoBwxxq7L7/view?usp=sharing

 

Axis value conditional format color.png

This has been a bug since conditional formatting for visual elements was added across the board. The rationale explained in other forum posts is that the label does not have filter context, but this seems like a scape goat as it should have as much filter context as the actual chart data point itself.

 

See https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Conditional-formatting-color-on...)

 

Or https://community.fabric.microsoft.com/t5/Desktop/Conditional-formatting-of-X-axis-values/m-p/267589...

Status: Investigating

Hi  @NarWind ,

 

Based on the above information, this is a reproducible issue. I would suggest opening a support ticket and the ticket support engineer will feed this back to the product team for further investigation.

 

if you are a Power BI Pro or Fabric licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you. 
It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

 

The link of Power BI Support: Support | Microsoft Power BI

For how to create a support ticket, please refer to How to create a support ticket in Power BI - Microsoft Power BI Community

 

Best Regards,
Community Support Team _ Caitlyn

Comments
v-xiaoyan-msft
Community Support
Status changed to: Investigating

Hi  @NarWind ,

 

Based on the above information, this is a reproducible issue. I would suggest opening a support ticket and the ticket support engineer will feed this back to the product team for further investigation.

 

if you are a Power BI Pro or Fabric licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you. 
It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

 

The link of Power BI Support: Support | Microsoft Power BI

For how to create a support ticket, please refer to How to create a support ticket in Power BI - Microsoft Power BI Community

 

Best Regards,
Community Support Team _ Caitlyn

NarWind
Advocate I
Hi @v-xiaoyan-msft - thank you for the reply. Is this a new process? In the past I have posted Power BI bugs on this forum and your team was able to pass them on to the product team. For example, this one from a few months ago: https://community.fabric.microsoft.com/t5/Issues/Combo-chart-area-below-line-transparency-not-workin...