Forum Discussion
Helper IICreate new table by transposing/Crosstab a data table
In matrix viusal , Week on column , Max of Status measure as value
Or if need a new table, Unpivot in Power Query- Take max of status -> If it does not give Option, After table is created you will see List.Count in script(formula), Make that List.Max
Post PatronThe Power Query unpivot approach is correct for reshaping data at the model level. One thing to note: unpivoting changes your data structure permanently, which can affect other visuals and measures that depend on the original wide format.
If the goal is to display the data in a crosstab layout (User as rows, Week as columns, Status as values) without restructuring the underlying table, the Matrix visual handles this directly put User in Rows, Week in Columns, Status in Values. No unpivoting needed.
For end-users who need to swap which dimension goes in rows vs columns themselves after publishing, Flexa Tables on AppSource adds this flexibility to the published report