Solved: Chart Looks at Different Data Set - Table - Page 2

MM_Group · 03-27-2023 08:55 AM

Hi Guys

Really strange this one.

I have a slice "InvoicedThisMonth" which is based on the table "qryInvoicedMinusCredits".

I'm creating a chart UX and changing the display name to: "Sales Total: " & SUM([TotalInvoiced])

The Expression Assistant cannot find the column [TotalInvoiced]. So if I look in the 'Columns' assistant the columns available in there are from a totally different table and not from the Slice.

I've double checked the UX 'For This Data' and everything is correct selected.

Expression Assistant Below, these Columns are not from the 'InvoicedThisMonth' slice ??

MM_Group

Thanks @Marc_Dillon very interesting.

But I'm not sure how I would apply that to this: (IGNORE ME)

"Sales Total: " & SUM(InvoicedThisMonthLessCredits[TotalInvoiced])

"Sales Total £: " & (ROUND(SUM(InvoicedThisMonthLessCredits[TotalInvoiced])*100)/100.0)

Many Thanks

View solution in original post