Forum Discussion

swapnilsd08's avatar
swapnilsd08
Frequent Visitor
9 years ago

Incorrect data representation in Power BI

Hello,   I am using SQL report to create a visual that gives me YoY, QoQ, MoM and DoD trend. I am using Timeline to select timeframe and a line chart to show the trend.   The report contains data...
Dashboards
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi swapnilsd08,

 

When we drill down all fields at once from Year level to Quarter level use this button , all data will be grouped by the Quarter values, so for Q1 it will display total values from both Q1 2016 and Q1 2017. This is same when you select months - Dec'16, Jan'17, Feb'17, it will group by Month ignore Year, so the order is Jan, Feb, Dec.

 

You can try to use the drill down one field at a time or Expand all down one level in the hierarchy . See: Drill down in a visualization in Power BI.

 

Best Regards,
Qiuyun Yu