Forum Discussion

IvanRivera4's avatar
IvanRivera4
Regular Visitor
9 years ago

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        | ...
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi IvanRivera4,

 

Current power bi not support to dynamic change group column, you should manually switch the group column to show different summary result.

 

Calculate column 'Range':

 

Range = INT([Age]/10)*10&"~"&(INT([Age]/10)+1)*10

 

 

Drag group, money, % columns to table, then switch summary mode of money and % column to sum. 

 

 

Result:

 

Regards,

Xiaoxin Sheng