Forum Discussion
Quarterwise Error
Hi Community,
I'm trying to show data Quarter and Monthwise using Drill down option.
Monthwise Data is Showing properly but when I'm trying to show it Quarterwise I'm not getting Total of 3 months that I should get instead It's showing me Data of last month in a Quarter.
Please Help!
4 Replies
Niraj_vora0106 , The error is not clear with your screenshot.
Ideally, you should create a date table and have Qtr year and a Month year. And then drag Qtr year and Month year on axis
Sir amitchandak
For Q1 if you see the total of 3 months for April-May-June should be 2515 - For Grey Line
and it should be 221 - For Green Line
instead it is showing Q1 as 906 (For Grey Line) and 135 (For Green Line) which are the Values of June month.
Ideally it should be Total of April-May-June in Q1 right.
and I've used this Hierarchy from Date Table.
Niraj_vora0106 , for that need to check your measure, is it using something like below in filter ?
date[Date] = max(date[Date])
ideally, it should be a simple measure.
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hi Niraj_vora0106 ,
Please check the date type of the value column, if the type is text, then the field added to the line chart will be First row of this column instead of sum.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
