cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## How to avoid Blank

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.

1 ACCEPTED SOLUTION
Frequent Visitor

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.

7 REPLIES 7
Frequent Visitor

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.

Super User

Hi,
Plrease try creating a new measure that looks something like below.

``````New Measure: =
[Total Qty] + 0``````

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Visit my LinkedIn page by clicking here.

Schedule a meeting with me to discuss further by clicking here.

Frequent Visitor

Hi,

This is my measure:

total_line2 =
var _sales = SUM('ProdManual Line_Line2'[Total Qty])
return
IF(ISBLANK(_sales),0,_sales)
It doesn't work. Maybe it is [Day] 's problem
Super User

Hi,

try this:

total_line2 =
var _sales = SUM('ProdManual Line_Line2'[Total Qty])
return
COALESCE(_sales,0)

Frequent Visitor

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]?

Super User

You could try that,

Maybe try the COALESCE on the Var before:

total_line2 =
var _sales = COALESCE(SUM('ProdManual Line_Line2'[Total Qty]),0)
return
COALESCE(_sales,0)

Frequent Visitor

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!

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors