Forum Discussion

Alicia_Anderson's avatar
Alicia_Anderson
Icon for Resolver I rankResolver I
5 years ago

Conditional formatting on tables vs matrix

I have conditional formatting set up on a table.  Problem:  I want to hide or gray out rows for the same Case.ID so that that information is not repeated.   In the example below, I only want to see t...
Need Help
MFelix's avatar
MFelix
Icon for Super User rankSuper User
5 years ago

Hi Alicia_Anderson ,

 

To what I can see from your screens shots you need to identify what is the row of the specific case id and if there is repetion.

 

What I did was to create two measure, one ranking by case ID and another for condittional formatting.

 

ranking based on case ID =
RANKX (
    FILTER (
        ALLSELECTED (
            'Table'[Case ID];
            'Table'[BUG ID];
            'Table'[DA Reason];
            'Table'[DA-ID]
        );
        'Table'[Case ID] = MAX ( 'Table'[Case ID] )
    );
    CALCULATE ( MAX ( 'Table'[BUG ID] ) );
    ;
    ASC
)

Condittional Formatting = if([ranking based on case ID] = 1 ;"#000000";"#00000000")

Now use the formatting measure to do the conditonal formatting for the values you want to hide:

Be aware that I have all the information in a single table if you have it in more than one table this needs to be adjusted but for that I would need to know how the model is setup.

 

To debug this and see if there are any columns you need to add or remove from the Ranking place that measure in your table visualization and then start changing the setup if the ranking gives you different Values for every row and starting at 1 at each case ID the formula is correct if you have duplicate values within the same ID then you have to change the measure.