Forum Discussion

mianjalil239's avatar
mianjalil239
Helper III
1 year ago
Solved

Who Can do This ?

Subject: Conditional Formatting on a Clustered Column Chart – How to Apply Conditional Formatting to Only One Column (Actual vs. Target) Question: Hello Power BI Community, I’m trying to apply con...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

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

    Hi, mianjalil239 
    Thanks for reaching out to the Microsoft fabric community forum.

    Regarding the issue you raised, my solution is as follows:

    Your initial approach is correct. Based on my testing, Conditional Formatting is available in the y-axis parameter of the Clustered Column Chart visual object only when there is a single field.


    Therefore, you simply need to add an additional condition to your Actual Color Measure:

    1.Firstly, my test data is as follows:

    2.Secondly, I have modified your Actual Color Measure to:

     

    Actual Color Measure =
IF (
    SELECTEDVALUE ( 'KPI'[KPI] ) = "Actual",
    IF ( [MTD Budget Actual] > [MTD Budget Target], "#FF0000", "#00FF00" )
)

     

    3.Next, adjust the custom visual object settings:

    4.Here's my final result, which I hope meets your requirements.

    Please find the attached pbix relevant to the case.

     

    Best Regards,

    Leroy Lu

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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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

Hi, mianjalil239 
Thanks for reaching out to the Microsoft fabric community forum.

Regarding the issue you raised, my solution is as follows:

Your initial approach is correct. Based on my testing, Conditional Formatting is available in the y-axis parameter of the Clustered Column Chart visual object only when there is a single field.


Therefore, you simply need to add an additional condition to your Actual Color Measure:

1.Firstly, my test data is as follows:

2.Secondly, I have modified your Actual Color Measure to:

 

Actual Color Measure =
IF (
    SELECTEDVALUE ( 'KPI'[KPI] ) = "Actual",
    IF ( [MTD Budget Actual] > [MTD Budget Target], "#FF0000", "#00FF00" )
)

 

3.Next, adjust the custom visual object settings:

4.Here's my final result, which I hope meets your requirements.

Please find the attached pbix relevant to the case.

 

Best Regards,

Leroy Lu

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

  • mianjalil239's avatar
    mianjalil239
    Helper III
    1 year ago

    Thanks its work 

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi,mianjalil239 
      We are absolutely delighted to hear that the issue has been resolved. If you’re inclined, you might consider accepting this solution, as it could also assist other community members facing the same problem, enabling them to find a resolution more swiftly      .

      Of course, if there is anything else we can do for you, please do not hesitate to contact us.

      Looking forward to your reply.

      Best Regards,

      Leroy Lu