Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a column called Month that is formated as Date/Time, Format: 2001-03(yyyy-MM). It looks correct in the model. I have a line chart where I would like to have both Month and Year visible, since I have data spanning more than one year.
The problem is that my chart can only display Year OR Month. If I select both Year and Month in the date hierarchy, I only get Year displayed in the chart. Any ideas?
Date hierarchy:
Model:
Solved! Go to Solution.
Ahh, obvisoluy missed that if you have a date hierarchy you have to drill down in the chart if you want to see both year and month....
Hey @matt_s ,
Please select your Date columna and check the name of your Date column like below screen shot.
Please give Thumps up for support and mark it as a solution if it helps you!
I found one way to solve this by created a calculated column storing the date values as text. But I'm having a hard time understanding that this should not work with a date column?
Ahh, obvisoluy missed that if you have a date hierarchy you have to drill down in the chart if you want to see both year and month....
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |