Hi,
could anybody tell me how to set up an attribute in power pivot in which you can filter your data.
Basically we have one sales file that we prepare, and upload in PQ, after that we unpivot columns that have financial data, but i can not make
an attribute like one on the picture, which you can drop in pivot table and filter it.
I do not have a lot of dax measures just MTD, YTD, and sum for the values. It a simple file.
could anybody tell me how to set up an attribute in power pivot in which you can filter your data.
Basically we have one sales file that we prepare, and upload in PQ, after that we unpivot columns that have financial data, but i can not make
an attribute like one on the picture, which you can drop in pivot table and filter it.
I do not have a lot of dax measures just MTD, YTD, and sum for the values. It a simple file.