Forum Discussion
Create table with dynamic pivot colum
Hi everyone, I'm new on Power Bi and I need to create a table in which I could change the pivot colum to see the same KPI Something like this: NAME | MONEY | % | JUAN | 100 | ...
P3Tom
Helper I
Helper IMy thoughts.
So your source table is going to have columns like:
Name, Gender, Age Range, Money
Just create you measures for Money and Percent. Manually replace Name, Gender, and Age Range for rows as needed (its just as easy as clicking a button).
Filter context takes care of the rest.