Forum Discussion
lucie_raboch
Helper II
Helper IIPivot table showing icons
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!!
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
1 Reply
- Kedar_Pande
Super User
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