Bug with Matrix icon formatting

[khoaphan_]

Hi, I applied Icon-Only formatting to my Values in a Matrix visual with multiple rows but it only applies correctly when all rows are collapsed. Once a row is expanded, the numbers are no longer replaced by icons.

Collapsed:

Expanded:

Icon formatting:

I am on the latest version 2.129.1229.0 as well. Thank you.

[Ritaf1983 · Accepted solution]

Hi @khoaphan_ 

I'm not sure if this is a bug, I think this is just how it works.

Anyway, to be safe, you can report the issue as an issue at the following link:

https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues

In the meantime, you can replace the generic option of the tool with DAX, for example:

orders qty formatted = if ([orders qty]>0 ,"✅","")

It works perfectly with hierarchies even when one of them is drilled :

The pbix is attached

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