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 there
I have a line graph which contains a measure as the value and a dim date table as the x axis.
The date table has values associated to the measure for every single month between 2016 and 2018.
The data is summarised by month so the date table only contains the first of every month.
I apply the date to the axis as a heirarchy in order to use drill-down. I would expect to be able to see year, quarter and month.
However, when I right-click and drill down on 2017, I am only getting January to October 2017 months appear. Why is November and December hiding? They have values associated them as you can see in the image below.
Why is this happening?
Hi @Anonymous ,
It's best to share us your .pbix file for test. Please remove sensitive information and unnecessary visuals. It is suggested to upload your file to OneDrive for Business and then paste the link here.
Best Regards,
Icey
@Anonymous See if you have not fixed the end value on the x-axis. Would appreciate if you could share data in text format instead of image.
Proud to be a Super User!
Hi, no I haven't fixed the end value. What I have noticed however, is that the four months showing are the first months of each quarter. It's just strange that it's showing this way
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 |
---|---|
117 | |
101 | |
69 | |
69 | |
43 |
User | Count |
---|---|
146 | |
106 | |
104 | |
89 | |
65 |