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.
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
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 |
---|---|
114 | |
100 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |