Measure in line chart is gone after publish

[PedroCardoso]

Hello guys, first-time post on this community!

I'm building a report based on JIRA data. I have a table with my JIRA issues, each issue as open and close dates. I created a table with all dates and created two relationships from my issues table to the dates table. One of those is disabled, as you can see in the following image.

I have then created two measures that count the number of issues opened and closed.

#Issues Opened = COUNTROWS(Issue)

#Issues Closed = CALCULATE(COUNTROWS(Issue),Issue[Issue is closed] = TRUE(), USERELATIONSHIP(Issue[Closed at],DateTable[Date]))

I then created a simple line chart with the measures above, all works great

All numbers seem to make sense. I've crossed checked with JIRA itself.

Now for the weird part... I publish my report to PowerBI and for a while, I can see both lines, but after a while, the ones with the closed issues is gone 😐

I have zero clues about what is going on here. Can someone help?

Thanks

[v-xicai · Accepted solution]

Hi @PedroCardoso ,

It seems like the online version of Power BI is treating/displaying Boolean values differently to the desktop client. Desktop client shows Booleans as FALSE and TRUE but online it's displaying them as 0 and 1. It is an issue having submit currently ,please vote the issue link https://community.powerbi.com/t5/Issues/Visualization-BLANK-after-refreshing-page-in-Power-BI-servic..., to improve the Power BI.

We also submitted this feedback to the product group internally, so that the product group can pay attention to this problem and speed up the issue repairing.

To work around this issue, you can switch it to 'text' data type, or replace TRUE with 1 and replace FALSE with 0 when using Boolean values.

Best Regards,

Amy

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

[PedroCardoso]

Thank you! I spent a lot of time trying to figure this out. Already voted in the idea.