Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm trying to show the result of a new column i created as one column within a barchart:
Spend + Prediction =
VAR _monthtoday =
MONTH ( TODAY () )
VAR _month_table =
MONTH ('Actual Spend + Firm'[Date] )
RETURN
IF (
_month_table >= _monthtoday
,
'Actual Spend + Firm'[Pred_Adj],
'Actual Spend + Firm'[ActualSpending_Loc]
)
The above code essentially creates a column by usinga certain value from either Pred_Adj or ActualSpending_Loc based on if the month is in the past or future. e.g. use Actualspending_Loc up until may, then use Pred_Adj.
In a table the data shows correct but in a column chart it splits the column into two bars:
Is there any way to merge the two blue columns into one? is this something i need to do in the DAX formula or the graph itself?
Solved! Go to Solution.
show the x axis field details of your chart.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |