Conditional Formatting for Filed parameters

[Srikanth_reddy]

Hi Everyone, 

Below is the Line and clustered cloumn chart,  In x-axis i am using "days remaing in a month"  
In cloumn y- axis i am using order/sales filed parameter and in Line Y-axis i am using the vs prev year , vs forecast , vs AOP field parameter. 
So my requriment is to do conditonal formatting the bars should show in orange color when bars are below the trend line and above trend line it should as blue color. 
it should be dyanmic changed. 

pls let me know how to achieve the conditinoal formatting for the bars shown in the pic 

thanks in advance 

[Srikanth_reddy · Accepted solution]

Couldn't achieve the Conditonal formatting using Field parameters, as an alternate approach i have created two calcualted tables with the 3 mesures name and used Switch function to calcualte the measure. I have used the column in the slicer and mesaure in the visual. simialry for the 2 measures as well. For conditonal formatting to apply  i have the compared the two measures which gave me the expected result. 

thanks for the help !

[v-achippa]

Hi @Srikanth_reddy,

Thank you for the response and confirming that your issue is resolved. I kindly request you to accept the post as "Accept as Solution" so that other community members who has similar issue will find it more easily.

Thank you for being part of Microsoft Fabric Community.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @Srikanth_reddy,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @Ritaf1983 for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if your issue is resolved? 

If not please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-....

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447....

Thanks and regards,

Anjan Kumar Chippa

[Ritaf1983]

Hi @Srikanth_reddy 

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.