Could you post some sample data and requirement so that someone can look into it.
I'm not totally clear on your expectations but see a possible solution attached
a question - are you able to change the data structure?
I pivoted the data so it looks like this
then the viz becomes this
I also had to sort the days manually
but the end result is
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
This is not csv or Excel data. I took one sample one from Sql DB and make it in excel.
Actual Requirement : List only the Zero's for all the 7 days measure and by Product as dimension.
Hope you got it.