Forum Discussion

mstefancik's avatar
mstefancik
Advocate IV
11 years ago

Too many values

Hi, I am building simple column chart which represents sold items by stores. We have 171 stores. I supposed to get 171 columns to see sales of every single store. After creation there is yellow tria...
Need Help
ronkochanowski's avatar
ronkochanowski
Frequent Visitor
8 years ago

I'd like to chime in on this topic as well.  For me it doesn't appear to be an issue with a visual, but with the data itself.  I have a a one-to-many join between a DateDimension table and HeadCounts table, as well as a Contributions table.  DateDimension contains columns for FiscalYear:

FiscalYear = CONCATENATE("FY-", IF(MONTH(DateDimension[DateKey])<=8,VALUE(FORMAT(DateDimension[DateKey], "YYYY")),VALUE(FORMAT(DateDimension[DateKey],"YYYY"))+1))

And FiscalMonth:

FiscalMonth = 
SWITCH (
    TRUE(),
    MONTH(DATEVALUE(DateDimension[DateKey])) = 1, "05-Jan",
    MONTH(DATEVALUE(DateDimension[DateKey])) = 2, "06-Feb",
    MONTH(DATEVALUE(DateDimension[DateKey])) = 3, "07-Mar",
    MONTH(DATEVALUE(DateDimension[DateKey])) = 4, "08-Apr",
    MONTH(DATEVALUE(DateDimension[DateKey])) = 5, "09-May",
    MONTH(DATEVALUE(DateDimension[DateKey])) = 6, "10-Jun",
    MONTH(DATEVALUE(DateDimension[DateKey])) = 7, "11-Jul",
    MONTH(DATEVALUE(DateDimension[DateKey])) = 8, "12-Aug",
    MONTH(DATEVALUE(DateDimension[DateKey])) = 9, "01-Sep",
    MONTH(DATEVALUE(DateDimension[DateKey])) = 10, "02-Oct",
    MONTH(DATEVALUE(DateDimension[DateKey])) = 11, "03-Nov",
    MONTH(DATEVALUE(DateDimension[DateKey])) = 12, "04-Dec")

At one point the error was indicating that PowerBI couldn't perform the function on varchar data types, so I added the DateValue function to the formula...to no avail.

 

Fiscal columns displaying blanks

Overall, there are over 800K records, but only approximately 1,000 that are not displaying the Fiscal info...the remaining rows display the info as desired.

 

Here's the error associated with the above table:

 

Any positive input towards a solution is greatly appreciated!

Ron