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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Beyers_Strydom
New Member

Visual only allowing the plotting of summarized column

Hi 🙂

 

I would like to plot 'budget' next to 'budget used to date' by projects in a clustered column chart. 'budget' is a column in my  data and budget used to date is a measure. When I add the 'budget used to date' in y-axis field and projects in x-axis fields, it works nicely.

Beyers_Strydom_1-1671546033999.png

 

When I then add the 'budget' variable, it only allows me to add a summarized version of the column. So for example I can only plot the sum/count/.. of the budget column next to each of my 'budget used to date' columns in the chart.

Beyers_Strydom_2-1671546160710.png

 

There is no option for me to say do not summarize:

Beyers_Strydom_3-1671546252460.png

I would like the budget for each project next to budget used. Please help! Thank you in advance.

 

 

 

1 REPLY 1
lbendlin
Super User
Super User

budget used to date is a measure.

Why would that be a measure?  Sounds like this is immutable and should be a column.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.