Create a Chart with Hierarchy of Month and Saturdays in that Month

[Ravikjinfo]

Hi,

I need to create a chart with X-axis having a hieracrhy of levels as below

Level 1-  Month - (Jan, Feb, March etc..) Data for all days in that month.

Level 2 - MM/DD (01/06, 01/13, 01/20) when i drill on January data need to be shown only for Saturdays of January.

I have fields MonthName(Jan, Feb) and MonthDay (01/01. 01/02, 01/03 etc) and DayName (Monday, Tuesday, Wenesday) as part fo my Date table.

Any help in creation of the hierarchy and the displaying in the chart will be greatly appreciated.

[v-chuncz-msft · Accepted solution]

@Ravikjinfo,

You may add a measure as shown below.

Measure =
IF (
    HASONEVALUE ( Table1[Date] ),
    IF ( WEEKDAY ( SELECTEDVALUE ( Table1[Date] ) ) = 7, SUM ( 'Table1'[Value] ) ),
    SUM ( 'Table1'[Value] )
)

[Ravikjinfo]

Thank you very much, it worked.