Forum Discussion

Sri1999's avatar
Sri1999
Frequent Visitor
1 year ago
Solved

Conditional Formatting

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
)


 





Need Help
  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    1 year ago

    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.

8 Replies

  • Vishal06's avatar
    Vishal06
    Frequent Visitor
    1 year ago

    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!

    • Sri1999's avatar
      Sri1999
      Frequent Visitor
      1 year ago

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

      • MFelix's avatar
        MFelix
        Icon for Super User rankSuper User
        1 year ago

        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.

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    1 year ago

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

  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    Icon for Community Support rankCommunity Support
    1 year ago

    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.

  • Sri1999's avatar
    Sri1999
    Frequent Visitor
    1 year ago

    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!!