Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
I am trying to create a calculated table to bucket my measures for visuals. I have the budget , forecast and LY measures built already all I have to do is to show the measures in columns with labels. Any thoughts?
@AnonymousI have the budget , forecast and LY measures built already all I have to do is to show the measures in columns with labels
If you already have your measures, and you want to put them in a visual like Barchart, a table or a Matrix, you don't need to create a calculated table.
Just select a table or a matrix from visualization, and drag and drop your measures to the value field.
@Anonymous - I have measures but not atrributes as Budget forecast and ly . How can i do that?
@sgsukumarancan you tell me what you want to do?
I can't understand what is the problem
@Anonymous. I have them as individual measures but they are grouped as budget or forecast
Hi @sgsukumaran,
If it is convenient, please share a dummy pbix file which can reproduce the scenario and your desired output, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)
Best Regards,
Cherry
I figured this out. I ended up creating individual measures and bucketed them using the following dax.
=SELECTCOLUMNS(
{("Budget", "eComm","YTD", [Revenue $'s (eComm) YTD], [eComm Budget YTD Var %])
}
, "Metric", [Value1]
, "Segment", [Value2]
, "Period", [Value3]
, "Dollars", [Value4]
, "Variance", [Value5]
)
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.