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