Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi there,
I am new to PowerBI, please excuse the newbie question.
I have a report pulling information from my VFP ERP system. What I don't know how to do is this:
The stock values for items we sell by size. There are 4 tables feeding the information for the report. One database has the style info and contains the stock amounts under columns named Stk1, stk2 ,stk3, etc. One of the columns has the size scale code, and another table has the size scale code with the sizes for each code.
I would like to show the size instead of Stk1, stk2, etc. I would like to see S, M, L as the headers.
How do I accomplish this? Any help would be most appreciated.
Thank you!
Hi there,
I would like to clarify my post.
I am creating a report which draws data from various VFP tables.
The main one contains information of items we currently have in the warehouse.
The report shows the style, the colors the item is available in, with the amounts currently in the warehouse, by size, with a total for each style/color.
Currently these are the column headers of my report:
What I want to see is instead of the table column headers stk0, stk1, etc, I would like to see the actual size descriptions:
As an example:
Every item has a different size scale. The item table contains a column called "scale" which shows the scale code say "A1" and the scale is PP 4 5 6 7 7X.
I want to replace the current column headers stk0, stk1, etc and replace them with the actual scale sizes.
So the report would should the headers and the quantity in stock below:
How do I accomplish the custom column headings?
Thank you in advance for any assistance.
Hi,
Remove the skttot column. Select the first 2 columns, right click on the heading and select "Unpivot Other Columns". In the Query Editor, you can now join this table with the other one which has the sizes.
We want to help you but your description is too vaugue.
Please write it again clearly.
Provide example input data as table text (not a screen print) so we can import the data to build a soution for you.
Also provide the example desired output, with a clear description of the process flow.
Dont share private data.
Take care to use the same table and field names in the input, output and description so we can understand your problem and help you.
You will get a quick response if you put time and effort into writing clear problem descriptions.
Vaugue descriptions waste your time and ourtime.
Look foward to helping you when the above information is forthcoming.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
104 | |
103 | |
87 | |
61 |
User | Count |
---|---|
162 | |
132 | |
131 | |
95 | |
86 |