The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
I have just noticed that our dates are not being formatted correctly in a hierarchy. I have added Date to a hierarchy called Calendar. This is definitely formatted as yyyy-mm-dd.
However if I add the hieratchy to Axis in a bar chart and drill down I get the following. So the date is mm/dd/yyyy hh:mm:ss AM/PM. IF you drill directly to the bottom of the hierarchy using the connected double down arrow the format is correct but not when you drill down from year to month to date.
This happens on a Stacked Column chart but on a Line and Stacked Column Chart I have discovered.
Hi @gooranga1,
Since @v-haibl-msft has already report this issue, you can take a look at below link:
Drill down on date in column chart displays date/time format
Regards,
Xiaoxin Sheng
User | Count |
---|---|
70 | |
67 | |
62 | |
48 | |
28 |
User | Count |
---|---|
113 | |
77 | |
65 | |
55 | |
43 |