Forum Discussion

vsteinbahs's avatar
vsteinbahs
Icon for Helper I rankHelper I
6 years ago
Solved

Conditional formatting of cell values in Matrix visual

Hi, I'm trying to highlight cell background in the Matrix visual where cell value is greater then the previous value in the same row.  Is it possible to do in the current version of Power BI?  A scr...
Need Help
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    Hi vsteinbahs ,

    You can create the following measure:

     

    Measure =

    var A = CALCULATE(SUM('Table'[Sales]))

    var B = CALCULATE(SUM('Table'[Sales]),DATEADD('Table'[Date],-1,DAY))

    return

    IF(A > B,"#FFFF00",BLANK())

     

    Then in Matrix Format, choose conditional format:

    ,

     enable Background color and select ‘Advanced controls’:

    choose Format by Field value and select previous measure under Based on filed

     

    Here is the demo , please try it:

    PBIX 

     

    Best Regards,

    Yingjie Li

     

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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

You can use dif between this day ve previous days, You need to have a date table for the same.

sales =CALCULATE(SUM(Sales[Sales Amount]))

Day behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Day))

Change = [sales]-[Day behind Sales ]

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s.

Refer
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi

https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin

  • vsteinbahs's avatar
    vsteinbahs
    Icon for Helper I rankHelper I
    6 years ago

    Thanks for your reply, I will check it out early next week and let you know how it goes.