How to use two measures in the same axis in graph bar

[laissaandrade]

Hello guys.

My database has 3 columns: 1. Amount, 2. Cost type (Gross or Allocation), Category (LTF, PLTF, Budget).

In our context we have: Gross + Allocation = Net

I need a bar chart where the axis only shows Gross and Net, comparing the 3 categories, like this graph below:

I'm having trouble doing that because "Net" it's not in the "Cost Type" column. It's the results of the addiction Gross+Allocation, like I said before.

Does anyone know how to do that? Thanks in advance!

[MFelix · Accepted solution]

Hi @laissaandrade

Create a disconnected table with the values

Gross and Net.  Then add a measure similar to this one

Group value =

       SWITCH(

            TRUE(), 

            SELECTEDVALUE(TABLE[COLUMN])  = "Gross",  [Gross], 

SELECTEDVALUE(TABLE[COLUMN])  = "Net",  [Net] 

) 

The Table[Column] should be replaced by the column name of the disconnected table,  also use that table for your axis value.