How to create bar graphs using measures as columns of a table

[sujitjena]

Hi,

I am trying to create a comparison bar graph (i used clustered column chart) using measures that are calculated off of columns of the same fact table. Basically the comparison is against Prior year. However, i am unable to replicate a similar one that can be easily picked up creating a manul table in excel(below snapshot). In the below graph, i have components of X-axis as measures Like Resource payroll, Load,seat and other, Other, Travel etc which are all measures (blue bars for actuals compared to PY orange bars). I tried creating a separate table using these measures as columns in PBi but didnt work. Any suggestions?

[amitchandak]

@sujitjena , PBI does not support legend with multiple measures. You need to have

Resource payroll, Load,seat and other has dimension values and year as legend

[Anonymous]

What error are you getting while creating a column and what is your formula?

[sujitjena]

@Anonymous :  Basically i tried columnadd and row functions to create a new table but both of them returned syntax errors which mean i may not have used them correctly. I have 2 measures each for actual and PY for all those components shown in the graph.