Sharepoint Datatype Yes/No -> Pbi Blank

[kintera]

I am connected to a sharepoint list which has no blanks in a Yes/No field, but PBi is showing blank. Why? I've viewed in Sharepoint via browser, and in Access and there is no blanks.

Thank you in advance

[Seth_C_Bauer]

@kintera Are you connecting via the Desktop? If so, you could remove the default "change types" maybe something is getting filtered out because it is changing the input. It could be that the list is displaying Yes/No, but is actually a boolean or something.

[kintera]

Hello, Seth. Thanks for the response... and offer, but I'm in SE Michigan.

I think I found the solution. I"m trying to add lines (or excel series) to a linechart and am merging (or Access Union) to create them. When I did the merge, I left a column out of one of the underlying queries resulting in blank. I don't think there's a way to omit columns from a merge. I'm also thinking I should have done  a pivot, which will duplicate other row/columns not included in the pivot. I'm new to PBi and am used to Access/SQL so it's a bit of an adjustment. I could do this on the Access/SQL side (my data goes Excel (system with no connection ability) >Access/VBA (User Interface for input) >Sharepoint(Governance/Reuse)>Pbi_Service(reporting)

I'm going to try a pivot... we'll see

You might know this, though. My Users want the a Total (I'm reporting by ReportDate - the day a datapull is done from another system) for all Late (boolean - either True or False) on a date. I was going to add a column and pivot on it (duplicating rows by ReportDate). Is that how you'd do it? 

again, thanks

Lex

[Seth_C_Bauer · Accepted solution]

@kintera merge should pull in all columns from the datasets, you just select which columns you want to merge on.... you also have the choice of how you want the merge to behave (join type). Alternatively, if you could try append as well to combine datasets.

As to your other question, I would recommend you spend some time understanding modeling and DAX, but as it pertains to this specific question. I would create a measure that would look something like this (Late = CALCULATE(COUNTA(<your field>), FILTER(<table where column lives>, <your field> = 1)) or since it is boolean you could likely SUM the value without the filter.

[kintera]

Thanks for the thought. I think I've got it. Have a great day! 🙂