cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
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 

 

salman_ali_0-1600954682679.png

 

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
Helper III

I hope someone can help me with this!

Highlighted

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

Hi Rena,

 

Sure

 

Here are the fields

 

salman_ali_0-1601036732652.png

 

 

Week_day_commit 

salman_ali_1-1601036843066.png

ForecastG

salman_ali_2-1601037079037.png

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

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

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

 

salman_ali_2-1601303220951.pngsalman_ali_3-1601303251664.pngsalman_ali_4-1601303388897.png

 

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

 

in the visualization field shown below

salman_ali_5-1601303546508.png

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

 

salman_ali_7-1601303740780.png

 

 

salman_ali_6-1601303684913.png

 

Data table

 

salman_ali_8-1601303864828.png

 

salman_ali_9-1601303909471.png

salman_ali_10-1601303950048.png

salman_ali_11-1601303981290.png

salman_ali_12-1601304018353.png

salman_ali_13-1601304043969.png

salman_ali_14-1601304084528.png

salman_ali_15-1601304111193.png

 

salman_ali_16-1601304150975.png

 

salman_ali_17-1601304182071.png

 

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

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