Forum Discussion

carlol's avatar
carlol
Resolver I
3 years ago
Solved

redact Aggregated Column value

Hi    Is it possible to redact QTY column ,   if Value is 5 or less it illustrated <5 But when aggregated it will still correclty sum the total , 2+ 10 = 12 . illustrated in powerbi visual is <5 &...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    3 years ago

    Hi， carlol 

    It's difficult to redact QTY column.

    You may need to add new fields like this:

    calculated column:

    New Qty = IF('Table'[Qty]<5,"<5",FORMAT('Table'[Qty],"general number"))

    measure:

    Result = 
 var tab=VALUES('Table'[New Qty])
 return CONCATENATEX(tab,'Table'[New Qty],"&")

    Best Regards,
    Community Support Team _ Eason

carlol's avatar
carlol
Resolver I
3 years ago

Thanks 

 

I was going to look at conditional formatting too , this is how you can implement in Excel 

 

 

 

 

 

v-easonf-msft's avatar
v-easonf-msft
Community Support
3 years ago

Hi, carlol 

Conditional formatting is basically infeasible.

Although PowerBI can also set conditional formatting, but it only applies to the background color, field color, icon, URL of cells in the table.

PowerBI does not support conditional formatting for the display of data format.

 

Best Regards,
Community Support Team _ Eason