Only display maximum value of dimension in chart

[marcusbohman]

I have a stacked bar chart with two dimensions. First, week formatted as an integer YYYYWW and then a category as string. I want to show only the latest week in the loaded data. (Not last week since the data from last week might not be loaded yet.)

How would I do that?

[vunguyenq89 · Accepted solution]

Use Set Analysis in your chart expression/ measure, for example =Sum({<WeekYear = {"$(=Max(WeekYear ))"}>} Sales)

[marcusbohman]

Perfect!