Correct measure but wrong visual display

[Mous007]

Hi everybody,

I have calculated a basic measure that counts the total in a column. the result is correct as you can see on the table but the visuals look weird for some reason. I think it might be related to a wrong relationship but i am not really sure.

I wish i could post the pbix file or an extract but i cannot unfortunatly.

Can anybody shed some light on this issue for me or at least share a tip about what i can check or change in order to solve this issue ?

thank you in advance,

[Mous007]

Hello guys,

Thanks a lot for trying to help.

I simply moved my data and measure to a new pbix file and everything is working just fine. I did not technically solve it but i guess it was something related to the file.

Thanks again.

[v-yiruan-msft]

Hi @Mous007 ,

First, could you please provide the formula of your basic measure "Total Controls"? It seems it didn't be aggregated when drag this measure onto visual...

In addition, what is the data type of the field Period? Is it date type? The format(2019001) is a bit strange...  Please also provide the screenshot of the fields which be applied onto visual (include the information circled in red in the below screenshot)? 

Best Regards

Rena

[VasTg · Accepted solution]

@Mous007 

Looks like you have a gap in the period. Could you atleast post Period and Total Controls data?

If it helps, mark it as a solution

Kudos are nice too