Forum Discussion

Mous007's avatar
Mous007
Icon for Helper IV rankHelper IV
6 years ago
Solved

Correct measure but wrong visual display

 

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,

Need Help
  • VasTg's avatar
    VasTg
    6 years ago

    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

3 Replies

  • VasTg's avatar
    VasTg
    Icon for Memorable Member rankMemorable Member
    6 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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

  • Mous007's avatar
    Mous007
    Icon for Helper IV rankHelper IV
    6 years ago

    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.