Is it possible to categorize (or group) calculated fields to display in a bar chart visual?

[Anonymous]

Hello!

I have six calculated fields (KPIs) that take the sum of annual and monthly impressions, shares, and clicks.

Sum_Annual_Impressions = SUM('source_data_view'[annual_impressions])

Sum_Annual_Shares = SUM('source_data_view'[annual_shares])

Sum_Annual_Clicks = SUM('source_data_view'[annual_clicks])

Sum_Monthly_Impressons = SUM('source_data_view'[monthly_impressions])

Sum_Monthly_Shares = SUM('source_data_view'[monthly_shares])

Sum_Monthly_Clicks = SUM('source_data_view'[monthly_clicks])

Ideally, I would like a bar chart that looks like this:

It would be grouped between Monthly and Annual, and each chart is split between the shares, impressions, and clicks.

Is there a formula that could possibly group or categorize the six calculated fields - where the three monthly are categorized/grouped as 'Monthly', and the three annual are categorized/grouped as 'Annual'?

[v-janeyg-msft · Accepted solution]

Hi, @Anonymous 

According to your description, You can try Stacked Column Chart by Akvelon custom visual.

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.