Displaying Blank Fields

[Anonymous]

I have a table that omits records with no revenue if there is no revenue to report:

From here I realize that in order to prevent this from happening, all I have to do right click the revenue field and select "Show Items With No Data":

My issue is that I've had to build a formula that calculates the revenue differently than just displaying it. The formula looks like this:

So since I'm using this calculated field rather than the raw revenue amount, I lose the ability to click on "show items with no data". So in my table for active clients for this user, it is only showing 2 accounts instead of the 8 that are active:

How can I also show accounts with no revenue reported but are still active regardless?

[TomMartens]

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]

@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.

[Anonymous]

I think I may have found an answer but I don't know how fool proof it is? If I add the revenue amount field to the table, then right click and select "show items with no data" then remove the revenue amount field since I don't want it displayed, it seems to stick?:

 If that's all I have to do then I won't make it any harder than it needs to be...