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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
salman_ali
Helper IV
Helper IV

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
salman_ali
Helper IV
Helper IV

I hope someone can help me with this!

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.

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 

 

 

 

 

 

 

 

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.

Rena, yes that is exactly what I am looking for, @v-yiruan-msft 

 

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.