Multidimensions: Problem with (Week and Date) as Dimensions in Bar chart

[geam1988]

Hi,

I am using bar Chart, 3 Dimensions and 1 Expression. 

I want to show Week and Date as Dimensions on X-axis and Mateial is also Dimension but on Y-Axis . My chart is showing Week and Date as Dimensions on X-axis but Date is not accurate as per week. It is showing additional date.

How can i show respective date as per week?   I want to show all date of that particular week( even there is no quantity available). 

Please see the QVW file.

Thanking You

Kazi

[Vegar]

I don't think what you want is possible as you want. An alternative solution is to swap date with weekday. IS this an alternative that will meet your needs?

[geam1988]

Hi Vegar, I need to show either date (24.04 or 24.04.2020) or Day (24).  Why is it not possible? Is there any logical reason? Thanks

[Vegar]

It is not considering this as a hiearchy,but presenting all combinations. Compare to what happens if I switch the date and week combination.