Forum Discussion

abrown's avatar
abrown
Regular Visitor
7 years ago

Power BI visualization issue

I am trying to do a bar chart showing the sum of defects for every week of the year. I already did the calculation in excel and successfully transferred the data table to power BI. Every week is show...
abrown's avatar
abrown
Regular Visitor
7 years ago

I have tried the previous replies.. Sum doesn't cut it either because it sums every defect and outputs the total # of defects for the year for every week number.

 

HotChilli's avatar
HotChilli
Community Champion
7 years ago

I can't get the full situation from the picture you just posted because the visualisation wasn't selected at the time you took the screenshot. 

But it does look like you don't have the correct datatypes on your fields in the PER WEEK table.

Link your pbix and i'll look at it

  • abrown's avatar
    abrown
    Regular Visitor
    7 years ago