topic Re: stacked chart limited? in DAX Commands and Tips

stacked chart limited?

Anonymous — Fri, 24 Feb 2023 12:06:44 GMT

Hi,

I have visiualized my data in a stacked chart, which works good if I choose the customers (here named as CYname) manually.

but as soon as I deselect the filter to have all customers the chart is empty.

Since I have a lot of data, is a stacked chart somehow limited or did I miss something?

Thanks

FreemanZ — Fri, 24 Feb 2023 12:31:53 GMT

hi Anonymous

what code do you have for the values field in your visual?

Anonymous — Fri, 24 Feb 2023 12:44:38 GMT

Hi FreemanZ,

all fields are directly from the table except the count is a measure:

Lost_Lu_count =

VAR _SummaryTable =

ADDCOLUMNS ( VALUES ( 'Date'[Date].[Monat] ), "@value", [Lost_Lu] )

RETURN

SUMX( _SummaryTable, [@value] )