Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Formatting rows unique to only one table visual

Hello everyone, I am new to DAX and I have been struggling to find a way to format rows of my table visuals, where I would like to highlight rows unique to each table visual. I have three visuals on ...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi, Anonymous 

     

    You can try the following methods.

    Measure = 
VAR _table1=CALCULATETABLE(VALUES(Table1[Commodity number]),FILTER(ALL(Table1),[BM number]=MAX(Table1[BM number])))
VAR _table2=CALCULATETABLE(VALUES(Table2[Commodity number]),FILTER(ALL(Table2),[BM number]=MAX(Table2[BM number])))
VAR _table3=CALCULATETABLE(VALUES(Table3[Commodity number]),FILTER(ALL(Table3),[BM number]=MAX(Table3[BM number])))
RETURN
SWITCH(TRUE(),
SELECTEDVALUE(Table1[Commodity number]) in EXCEPT(_table1,UNION(_table2,_table3)),1,
SELECTEDVALUE(Table2[Commodity number]) in EXCEPT(_table2,UNION(_table1,_table3)),1,
SELECTEDVALUE(Table3[Commodity number]) in EXCEPT(_table3,UNION(_table1,_table2)),1,0)

    Color measure = IF([Measure],"Yellow",BLANK())

    Then add conditional formatting to each field.

    Is this the result you expected?

     

    Best Regards,

    Community Support Team _Charlotte

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

BIswajit_Das's avatar
BIswajit_Das
Icon for Impactful Individual rankImpactful Individual
1 year ago

Hello Anonymous 
Is your required result is something like the below SS

If yes then you can create a conditional measure with DAX

check =
VAR _chck =
CALCULATE(
    COUNTROWS('Table1'),
    REMOVEFILTERS('Table1'[BM number])
)
RETURN
IF(_chck > 1 , 0 , 1)
then add conditional formating on columns of the table

Thanks & Regards...
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi BIswajit_Das,

 

Thank you for your time! My required result is similar to your SS, here is a sample SS of the pbix before the conditional formating:

 

Unfortunately, when I used the measure that you suggested and added it to my table visual, it resulted in all 0 despite there being some rows that are unique to that table. I'm also not sure if I follow your logic of using REMOVEFILTERS, could you explain how you achieved the result in your SS with it?

 

My three datasets are all duplicates and are identical if that helps 🙂 

 

Thanks again!

  • BIswajit_Das's avatar
    BIswajit_Das
    Icon for Impactful Individual rankImpactful Individual
    1 year ago

    Hello Anonymous 
    You need to use the created measure on the condition formating like the below SS

    after the measure creation select the data visual then

    expand/right click on the used columns  -> Conditional Formatting  -> Background Color ->

    Then select the format style to Rules as shown in the SS  -> Apply conditions and click on "ok" to apply the format on the data visual.
    Thanks & Regards...

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi BIswajit_Das,

       

      Thank you for your explanation! I'm not too sure why it does not work for my sample or my actual data for my side, but I will look into it and let you know if I managed to get it to work.