Forum Discussion

Kolumam's avatar
Kolumam
Post Prodigy
8 years ago
Solved

Issue with Combo chart

Hi All,   I have the below chart where I am representing The X-axis in Timestamp (DD:MM:YY HH:MM: SS). Instead of showing as 1 Jan, I want it as Mon. But if I force it to show as Mon, it cumulates ...
General Comment
Need Help
Show and Tell
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Kolumam,

     

    As there are multiple duplicated weekdays in a month, when you add WeekDay onto X-axis, by default, all values will be summed up. 

     

    In your scenario, you can new a calculated column which combines DayNo and WeekDay name so that each WeekDay is unique.

    WeekDay = Table[Date].[Day]&"-"&FORMAT(Table[Date],"DDD")

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi Kolumam,

 

As there are multiple duplicated weekdays in a month, when you add WeekDay onto X-axis, by default, all values will be summed up. 

 

In your scenario, you can new a calculated column which combines DayNo and WeekDay name so that each WeekDay is unique.

WeekDay = Table[Date].[Day]&"-"&FORMAT(Table[Date],"DDD")

Best regards,

Yuliana Gu