cancel
Showing results for
Did you mean:
Highlighted
Helper III

## adding multiple column of data on a stacked column chart

Hi guys, need some help

I have this stacked column chart right now.

legend = Forecast type

Y axis - Count of orders

and X axis - day of the week

As you can see this is based on one week, if we add rolling weeks to this data, the new data gets split into each of the weekdays, making it hard to see what rolling week the number represents.

Our ops team wants to identify which rolling week does each number represent.  Can we do that?

5 REPLIES 5
Highlighted
Helper III

I hope someone can help me with this!

Highlighted
Community Support

Hi @salman_ali,

Could you please provide some sample data which applied in the visual(include day of the weekForecast type, rolling weeks and order info)? If it involve any sensitive data, please mask or exclude it. Besides that, if the field which applied in Y axis(count of orders) is measure or calculated column, please provide the related formula.

By the way, how to rolling weeks? Per 2 weeks or this is a kind of accumulation by weeks? Please provide your desired result with the example.

Best Regards

Rena

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

Hi Rena,

Sure

Here are the fields

Week_day_commit

ForecastG

sample ForecastG data

DOW

DOW

KFA

RTB

Sensor

Rolling-week

Rolling Week =
if([Days Out]>28,"Ignore",if([Days Out]>=22,"Next 22 to 28",if([Days Out]>=15,"Next 15 to 21",if([Days Out]>=8,"Next 8 to 14",IF([Days Out]>=1,"Next 1 to 7 days","Ignore")))))

count of orders - just a count of account number column

weekday_column

weekday_column = SWITCH(WEEKDAY(OrdersPending[Due_CommitDate]),1,1,2,2,3,3,4,4,5,5,6,6,7,7)

Right now Rolling week is in a slicer, What I want to see is that I want the visualization to change when I choose the correct date range in the rolling week

Highlighted
Community Support

Hi @salman_ali ,

So your problem is how to make the visual display the data base on the Rolling-week slicer selection? Could you please provide some sample data in table OrdersPending in order to provide you with a suitable solution? Days Out is a fact field or measure? It is better if you can provide a sample pbix file. Thank you.

Best Regards

Rena

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

Rena, yes that is exactly what I am looking for, @yingyinr

i am sending screen shots of some of the columns in order pending table

Forecast G - could be DOW, RTB, DBD, WC and WCp

in the visualization field shown below

COUNT OF ORDERS is basically - count of LOCATIONS in orderspending table

----------------------------------

now I will share what I have in the Date Table

first off here is the slicer and fields

Data table

hope this makes sense, and if you can help.  Sorry I am not sure I know how to send the sameple file

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Microsoft Power Platform Communities

Check out the Winners!

#### Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors