Forum Discussion

cubedweller's avatar
cubedweller
Regular Visitor
8 years ago
Solved

clustered column chart displaying incorrect count based on new column

I created the following two New Columns: 1) Completed Past Due = SWITCH(TRUE(), CV_EC[Task Due Date] < CV_EC[Task Finished Date] && NOT(ISBLANK(CV_EC[Task Finished Date])) && CV_EC[Status]="Complete...
Need Help
  • cubedweller's avatar
    cubedweller
    7 years ago

    Hi Yuliana,

    I found the problem.

    It was a data issue. 

    The graph is working fine now.

    Thank you.

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi cubedweller,

 

It's hard to say what caused the incorrect value in chart and card visual based on current information. Would you please share your .pbix file so that I can check? Remove senssitive data before uploading.

 

Best regards,

Yuliana Gu

 

 

cubedweller's avatar
cubedweller
Regular Visitor
8 years ago

Hi Yuliana,

I'd rather not upload my .pbix file.

I'm guessing it's just a minor issue that I'm not seeing. 

Would I be better off creating a new measure instead of a new column?

If so, how should I change my new column formula (shown below) in order to work as a new measure?

 

Completed Past Due = SWITCH(TRUE(), CV_EC[Task Due Date] < CV_EC[Task Finished Date] && NOT(ISBLANK(CV_EC[Task Finished Date])) && CV_EC[Status]="Completed", 1, BLANK())

 

If you don't think this is the issue can you recommend any other ways to isolate what's causing the incorrect values?

 

Thank you.