Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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êsJoin the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
85 | |
85 | |
69 | |
67 | |
63 |
User | Count |
---|---|
213 | |
124 | |
117 | |
81 | |
75 |