How to group measures to display on a Power Bi Clustered chart?

Question

I have several measures computed and I am placing them on the Line and Clustered column chart to display them side by side. The challenge I am having right now is i can not group them for displaying on the Chart. Please see the attached screenshot.

As you see all the measures are appearing one next to the other, total of 10. I want to separate them and show them as a group of two. Is this possible to do, may be by using other type of chart? I have to use the measures coz they contain computed values from the dataset imported.

If any one has an idea over this, please help. Thanks in advance.

Answer 1

Create a new table with one column containing all of the groups that you want. For example: Gross, Net, and Total and put that Group column on the clustered bar chart axis.

Create a measure for the first bar of each group and a measure for the second bar each group. For example:

Actual = SWITCH(SELECTEDVALUE(Groups[Group]),
             "Net", [NetActual],
             "Gross", [GrossActual],
             "Total", [TotalActual])

Budget = SWITCH(SELECTEDVALUE(Groups[Group]),
             "Net", [NetBudget],
             "Gross", [GrossBudget],
             "Total", [TotalBudget])

Now put the Actual and Budget measure on in the bar chart Value field and you should get something like this: