Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
After filtering the data, both Day and Total Qty are blank.There is no data of last 40 days, so the dashboard is Blank. How to display 0 on the dashboard?
[Day] and [Total Qty] does not have last 40 days' data.
[Day] is Date.
[Total Qty] is Number.
Solved! Go to Solution.
I solved problem.
Of course need to create a measure for [Total Qty], but still to make a little change on [Date].
I created a table that data is from Today to Last 40 days.
And I related the [Date] and [Day]:
Finaly, it displayed ZERO.
Thanks for your help!
I solved problem.
Of course need to create a measure for [Total Qty], but still to make a little change on [Date].
I created a table that data is from Today to Last 40 days.
And I related the [Date] and [Day]:
Finaly, it displayed ZERO.
Thanks for your help!
Hi,
Plrease try creating a new measure that looks something like below.
New Measure: =
[Total Qty] + 0
Hi,
This is my measure:
Hi,
try this:
It is still Blank.
[Day] and [Total Qty] are blank in the table, because there are no data of last 40 days.
Maybe i should create a measure for [Day]?
You could try that,
Maybe try the COALESCE on the Var before:
Hi, @DOLEARY85
I just tried the COALESCE on the Var before, but it doesn't work.
I think maybe it is [Day]'s problem.May I ask you how to create a measure for Date.
Thank you!