Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Clustered Column Chart Help

Hello Experts, I have a situation, and was hoping if you could help me. I have a table with FY, and a few area columns with the score. I then pivot it to have Area Avg by FY. Below is the screen shot...
Need Help
Show and Tell
Tips and Tricks
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Anonymous,

 

Can you share the original data please?

How about adding a calculated table as bellow?

middle_table =
SUMMARIZE (
    'table1',
    'table1'[FY],
    'table1'[area],
    "average_value", AVERAGE ( 'table1'[value] )
)

Best Regards,

Dale

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Dale, thanks for your response, and sorry for the delayed reply. Creating a calculated table is not helpful. if we go with a calculated table, we loose the granular level filtering capabilites. This is the reason, why I could not go for transpose option. I will try to create a mockup dataset and share with you.

     

    Thanks