Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Matrix table subtotal

Hi

i am trying to do this on a matrix table in powerbi, i have suceeded in putting a colout red for negative values for subtotals but i want to drill to another visuals that shows only the red subtotals meaning where the subtotal is negative value.

i wrote a measure that shows this but it is fltering all the negative values i only want it to filter per catergory subtotal with a negative value .

 

Please can anyone help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Anonymous , Those drilled visuals need to have a filter on measure value <0, Measure can not pass the filter, only categorical data (row/column) can be passed.