Forum Discussion
Solved
Hide blank rows when data exists, otherwise show blank.
Hi all, A strange one, I have the following table: CustomerID Product Name Customer Status 1001 Laptop Active 1002 Smartphone Inactive 1003 Tablet Active 1004 Active ...
Create a Calculated Column
ShowRow =
IF(
'Table'[Product Name] <> BLANK() ||
COUNTROWS(
FILTER(
'Table',
'Table'[CustomerID] = EARLIER('Table'[CustomerID]) &&
'Table'[Product Name] <> BLANK()
)
) = 0,
1,
0
)Add the calculated column ShowRow to your table.
Apply a filter on the visual: ShowRow = 1.💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn
Kedar_Pande
Super User
Super UserCreate a Calculated Column
ShowRow =
IF(
'Table'[Product Name] <> BLANK() ||
COUNTROWS(
FILTER(
'Table',
'Table'[CustomerID] = EARLIER('Table'[CustomerID]) &&
'Table'[Product Name] <> BLANK()
)
) = 0,
1,
0
)
Add the calculated column ShowRow to your table.
Apply a filter on the visual: ShowRow = 1.
💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn
Perfect - just what I needed!
