Forum Discussion
Date Table relationship issue
Date Table relationship issue https://1drv.ms/u/s!AhVscPhmToJ0k7gcVSus_llQdKYNKQ When I use date-time column (CreatedOn.1) in existing table, column chart visual is working well. I cre...
Hi Anonymous
your createdOn.1 Column contains time, when you join to the Date table you are not matching any of the dates there, can you create a column that is just the date portion in your source system or through power query?
You will find your pbix file updated with a calc column that joins to the date table to slices your data by date, I would not suggest joining on calc dax columns and would try to push creating column work to your source system or powery query
https://1drv.ms/u/s!AhCeuF2piSWMgcBRvlzvUfBvxtNL5A
I Hope this helps,
Richard
Hi Anonymous
Its not picking up Values. Thats why chart is not showing columns for each dates.
I tried it with and without Hierarchy options, not working :(
hmm. that's wierd. Ill take a look