Forum Discussion
Clustered bar chart - conditional format
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.
5 Replies
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.
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
amitchandak I am sorry. I am not able to put the values in x-axis. Don't know why.
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.
Thank you for your suggestion Anonymous
