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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
nenedeloscojone
Frequent Visitor

Displaying item sizes

Good day,

 

I need help in displaying the sizes for clothing items.

 

Right now in my report, the size buckets headers show the field name. I am pulling the data from VIsual Foxpro databases. The size information is in it's own database file.

 

I want to see the actual sizes for each style. Not every style has the same size range, so I would need to be able to see the various sizes of the styles on the report.

 

nenedeloscojone_0-1666105371355.png

How do I show the sizes, instead of the field names?

 

Any help would be most appreciated.

 

Thank you!

2 REPLIES 2
nenedeloscojone
Frequent Visitor

Hi @v-yanjiang-msft ,

Thank you for replying to my post!

 

I am pulling the data from VFP databases. Not sure why there are multiple instances of the values. 

 

So right now, in my report I am showing the field names from the database. I want to see the actual sizes for each size bucket as shown below:

 

nenedeloscojone_0-1666211381689.png

The scale information is in another dbf, which the report if drawing from as well.

 

Hopefully I am explaining myself clearly.

How do I have the report do the correlation for the columns and the sizes?

 

Any help is most appreciated.

 

Thank you!

v-yanjiang-msft
Community Support
Community Support

Hi @nenedeloscojone ,

From what I got, if stk is the size you said, they show the same value in each row, but you want it's different in each row?

vkalyjmsft_0-1666173691982.png

Not sure what's the formula of stk, but if they can't recognize the for example prepak column, you can just add a condition like this:

CALCULATE(SUM(),[prepak]=MAX([prepak]))

Hope it make sense, if not, please provide more information.

 

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.

Top Solution Authors