Forum Discussion
itsmeanuj
Helper IV
Helper IVToggle columns to be group by
Hi, I have a dataset of customers by product where PROD_CD is a subset of POD_GRP. Below is the sample. Input Data Customer PROD_CD PROD_GRP Month1 Month2 Month3 A1 Product1.A Prod...
Hi itsmeanuj ,
In Query Editor mode, choose columns [PROD_CD] and [PROD_GRP], click "unpivot columns".
Rename columns.
Save above changes. In report view, drag [Slicer Items] into slicer and other fields into table visual.
Best regards,
Yuliana Gu
v-yulgu-msft
Microsoft Employee
Microsoft EmployeeHi itsmeanuj ,
In Query Editor mode, choose columns [PROD_CD] and [PROD_GRP], click "unpivot columns".
Rename columns.
Save above changes. In report view, drag [Slicer Items] into slicer and other fields into table visual.
Best regards,
Yuliana Gu