Clustered bar chart - conditional format

[Thulasiram]

Dear all,

I have created a clustered column chart with two values in Y axis and dates in x axis.

I want to conditional format one of the values but in format pane there is no option available.

No fx option available

But in another column chart I found the fx option.  In that it shows "Apply settings to" Categories.

I am confused.  Pls hhelp.

[Anonymous]

Thanks for the reply from @amitchandak , please allow me to provide another insight: 

Hi  @Thulasiram ,

As far as I know, this is due to the design of Power BI. In the Clustered bar chart visual, the fx option is displayed when one value is placed on the Y-axis, but not when the Y-axis has two values or when there are fields on the Legend.

Refer to:

Solved: Missing fx clustered bar chart colour? - Microsoft Fabric Community

You can submit an idea for it at Home (microsoft.com) and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Thulasiram]

Thank you for your suggestion @Anonymous 

[amitchandak]

@Thulasiram , if you are using legend, you can not use conditional formatting, you can instead use both of them X-Axis, expand, and Switch of Concatenate label. And now you can use conditional formatting

Shown in this: https://www.youtube.com/watch?v=QgI0vIGIOOk

[Thulasiram]

@amitchandak I am sorry.  I am not able to put the values in x-axis.  Don't know why.

[Thulasiram]

If I put only one value in y axis, then the conditional format option shows.  But for 2 values in y axis, it doesn't.