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?
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.
Here are the fields
sample ForecastG data
count of orders - just a count of account number 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.
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
hope this makes sense, and if you can help. Sorry I am not sure I know how to send the sameple file
This is a must watch for a message from Power BI!
Click here to read more about the December 2020 Updates!
Click here to read the latest blog and learn more about contributing to the Power BI blog!
Mark your calendars and join us for our next Power BI Dev Camp!.