cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ycavazin
Regular Visitor

Table Structure for Total Available Inventory to display in Stacked Column Chart Visual

Hi,

 

I have a table that looks like this:

 

idcreationupdatestatus
1JanuaryJanuarycreated
2JanuaryJanuarycreated
3JanuaryFebruaryDone
4FebruaryFebruaryInProgress
5FebruaryMarchDone
6FebruaryAprilDone
7MarchMayDone
8MarchMarchInProgress
9JuneJunecreated
10JulyAugust

Done

 

I want this table to look like this:

 

MonthCreatedClosedAvailable
January003
February315
March216
April015
May014
June105
July106
August015

 

so I can create a visual like this:

 

 

Can someone please guide me?

 

Thanks.

Yuri

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: Table Structure for Total Available Inventory to display in Stacked Column Chart Visual

hi, @ycavazin 

You may refer to this post:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365

For your case, just create three measure for created, Closed and Available by adding a conditional in the formula.

If you still have the problen, please share your expected output based on the sample data.

 

Best Regards,

Lin

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

View solution in original post

1 REPLY 1
Community Support
Community Support

Re: Table Structure for Total Available Inventory to display in Stacked Column Chart Visual

hi, @ycavazin 

You may refer to this post:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365

For your case, just create three measure for created, Closed and Available by adding a conditional in the formula.

If you still have the problen, please share your expected output based on the sample data.

 

Best Regards,

Lin

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

View solution in original post

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors