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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.