Forum Discussion
How to Have Visual Show All Months up to Present
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!
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.
1 Reply
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.