Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
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 week, Forecast 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
Hi Rena,
Sure
Here are the fields
Week_day_commit
ForecastG
sample ForecastG data
DOW
DOW
KFA
RTB
Sensor
Rolling-week
count of orders - just a count of account number column
weekday_column
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
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
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
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |