Pivot table showing icons

[lucie_raboch]

Hello,

Is there any way to force PowerBI NOT showing icons here? I tried to hide it, but without success.

when I unroll the table, it's absolutely OK

Thank you very much!!

[Kedar_Pande · Accepted solution]

Measure:

ShowIcon =
IF(
ISINSCOPE('YourTable'[SubLevelColumn]), // Check if in scope of a child level
1,
0
)

Under the field/column where you want to conditionally show icons, apply Icons formatting.
Rules: Set up a rule:
Format icons when ShowIcon equals 1.
If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn