The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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!