How to Have Visual Show All Months up to Present

[efogelberg]

Howdy everyone,

I have a predicament. Currently I have a PowerBI page that is pulling data from a large spreadsheet and counting "failures". I've dumbed down the spreadsheet for example purposes but it is similar to this:

We track events where some events are "failures", others are not but need tracked. The visual I have is only pulling and counting number of failures but doesn't show months since then without any failures and looks like this:

It's not that it's not showing data with value = zero. There's just that there's no data to count. Is there a way to have the visual show JAN-present like the below without having to make a separate spreadsheet to track this data? Thanks in advance!

[v-kaiyue-msft · Accepted solution]

Hi @efogelberg ,

1. Create measure and count the number of failures.

Measure =
CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'),'Table'[Failure] = "Yes" && MONTH('Table'[date]) = MONTH(MAX('Table'[date]))))

2. Right click the field on x-axis, tick "show items with no data".

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.