Date Hierarchy Doesn't show

Hi,

I have this Contact date & Total service by Clinicians. When I drag & drop the contact date to Columns, It doesn't show the Date Hierarchy option at all (Image 2) Am I missing somethin? And Sorting only shows by Note Writer(clinician) & Total Service Hour. There is no Contact Date in the sorting option in the Mtrix Visual (Image 1)

Will appreciate any help.

Thanks,

spanda

Need Help

v-yulgu-msft
7 years ago
Hi Anonymous,

Did you establish relationship with an other table based on [Contact date]? If so, it won't show hierarchy when adding [Contact date] to visuals.

Regards,

Yuliana Gu
v-yulgu-msft
7 years ago
Hi Anonymous,

It is not able to directly sort "Matrix Column headers". However, you can change the default sort order by adding a reverse index. Or you can add any custom order. Please refer to below links:

Matrix Column Head Order

Matrix visual sorting column

Best regards,

Yuliana Gu

13 Replies

v-yulgu-msft
Microsoft Employee
7 years ago
Hi Anonymous,

Did you establish relationship with an other table based on [Contact date]? If so, it won't show hierarchy when adding [Contact date] to visuals.

Regards,

Yuliana Gu
- carolinamg
  Frequent Visitor
  7 years ago
  Hello. I have this situation and I do have a relationship with another table: there is any solution or workaround for this?
- waleed111
  Helper V
  5 years ago
  so what is the solution, how we can show the hierarchy while keeping the relationship?
- Anonymous
  Not applicable
  7 years ago
  O I see... that's the reason then. Thank you!!
  In this case My another question was, If i choose the month(Another Column) from Contact date & use that, why can't I sort by Month ? It doesn't show in the sorting list. It only shows Clinician (Note writer) & Total Hour.
  
  Thanks for the help!
  spanda
RMDNA
Solution Sage
7 years ago
Hi Anonymous,

It doesn't look like your Contact Date field is formatted as a Date type. Try changing that and see if it works.
- hugomarquez
  Frequent Visitor
  6 years ago
  Hello RMDNA,
  
  Why if everything everywhere is set as Date Format, still does not show as Date Format? Here's a link to image showing this problem...
  
  https://1drv.ms/u/s!AoVKuGR4By59g-7xc18st05gOYd_KE4?e=W3A9A4
  
  Date not Showing Date Format
Baskar
Resident Rockstar
7 years ago
Change the column data type into Date. Now current column data type is Text.

Change it from Modelling screen.
- Anonymous
  Not applicable
  7 years ago
  Yes the Data type is already Date.
  
  Thanks,
  spanda
- Anonymous
  Not applicable
  7 years ago
  Here is the Data type
  - Baskar
    Resident Rockstar
    7 years ago
    Anonymous
    Cool.
    Have to enable the preview feature.