Forum Discussion

TomMartens's avatar
TomMartens
Super User
8 years ago

Hey,

 

Basically you can activate "Show items with no data" on any colum. Not just on numeric columns.

 

But you have to be aware, this will show rows for any available value, maybe this is not what you want.

 

I guess you have to think of a measure called "acitve customer" the value is 1 or blank. Now you can use this measure as filter on your visual.

 

Hopefully this gets you started

 

Regards

Tom

Anonymous's avatar
Anonymous
Not applicable
8 years ago

TomMartens Hey Tom,

 

Thanks for the reply! I've actually done that on this table beforehand to show only active clients. Issue was just with associating the revenue with those accounts since PBI naturally wants to rid rows with no revenue even if it is an active client. My little workaround of adding the revenue amount field to the table, clicking "show items with no data" to get all accounts displayed, then removing the revenue amount field seems to work somehow. I've found what I was looking for which was this:

 

Previously it was only showing the 2 accounts with revenue popluated.