Forum Discussion
PBI Service Data <> Local Data after Publishing
Ok so here's what i've found. I have a T/F column coming from my SQL source that is formatted in PQ as True/False. For some reason, it was transformed in PBI (not PQ) to a text column. I use this column in a switch statement. However, when i publish to the service, and i add that column to the filter pane, it gives me the option of 0 and -1, instead of "True" and "False".
To further the True/False column, if i select the (-1) {which should be a "true" in text at this point} in the filter pane, i get a popup that says "This visual contains one or more filters with deleted columns, type mismatches, or other breaking modeling changes" and the visual errors off.
so i've identified the issue, now to fix.
thank you for the willingness to help!
Super UserHi caseyace
What happens if you click on the reset to default button does that make the measure change at all?
This is just to see if there is some filter causing this to appear to be wrong?
Tried that, no luck.
I've managed to narrow it down to this. The measure in question contains a switch true that looks for 3 statuses, "closed", "In progress" and "unstarted". It is omitting the "In Progress" status. So I've added the status to the filter pane, and sure enough when I filter for "In Progress" only, the row goes blank. The odd part about it is that if i add the measure to another table, I have no issues with it.