Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
jonbox
Helper II
Helper II

Merge columns in column chart

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:

jonbox_0-1651569386765.png

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?

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

show the x axis field details  of your chart.

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

show the x axis field details  of your chart.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.