Conditional Formatting

[Sri1999]

Hello there,
I have a visual that is acting funny.

Context: In a matrix visual, I dropped calculation group to the column headers. I dropped Measures in values, by default it is showing like this which is not as expected.

I switched values to rows and it is as expected. 

When I'm trying to apply conditional formatting it is applying for entire row of Demand revenue. 

I want the conditional formatting to apply for vs Budget column only. If value in that column is negative it should show red and positive it should show green. 


Someone please help with this. Thanks inadvance.
Any additional info needed, I'm happy to help.


Column header calculation 

Daily Actual = CALCULATE(SELECTEDMEASURE(), 'Time Intelligence'[Period of time] = "Daily")

Time Intelligence is also a calculation group.
Daily =

VAR selectedDate = MAX(Dates[Date])

RETURN

CALCULATE(

    SELECTEDMEASURE(),Dates[Date] = selectedDate

)

[Sri1999]

Hi @v-pnaroju-msft 

I sincerely appreciate your efforts in helping me. This is a great headstart for me, I will be able to proceed further from here on. Thanks again!!

[v-pnaroju-msft · Accepted solution]

Thank you, @MFelix , @Vishal06 , and @danextian , for your responses.

Hi Sri1999,

We sincerely appreciate your inquiry posted on the Microsoft Fabric Community Forum.

Please find attached a sample PBIX file for your reference, which reflects the progress we have made so far. We kindly request you to review the file and inform us if it helps in resolving the issue.

Should you have any further questions or require additional assistance, please do not hesitate to contact the Microsoft Fabric Community.

Thank you.

[danextian]

This is the thing I hate most about calculatation groups. Selective conditional formatting is a royal pain.

[Vishal06]

Hi,

If you are able to use Tables visual instead of Matrix visual, you can implement formatting with the help of the following steps:
1. Go to 'Specific Column'.
2. Select 'Vs Budget'

3. Select the formatting -> which can be applied to the total and header if required. 

Hope this helps!

[MFelix]

Hi @Sri1999 ,

When you start to apply the calculation groups the condittional formatting does not get that easy.

Check this tutorial that will guide you with the expected outcome:

https://www.youtube.com/watch?v=Y3d5CrVbbis

https://www.youtube.com/watch?v=YU5nddHQ-oo

[Sri1999]

Thanks, I will follow the video. I hope it helps me to get through it. 

[MFelix]

If you need any further assistance just let me know,  but if you are able to get it solved don't forget to mark the correct answer so it can help others.

[Sri1999]

Sure, is it possible to connect on zoom? I am not able to get it.