Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to Solution.
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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português
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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
99 | |
86 | |
78 | |
75 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |