Forum Discussion

KWelsh8144's avatar
KWelsh8144
Icon for Helper II rankHelper II
7 years ago

Average on same graph as actual count per facility

    I currently have a chart that I produce in Excel that I need to generate in Power BI. The chart shows the averages by month for a certain group of facilities on one line and then th...
Data Modeling
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi KWelsh8144, 

 

You need to set the month values (2017 Nov, 2017 Dec,..,etc) in one column field. Assume the raw data looks like below: 

 

 

You can select the columns 2019-1 and 2019-2 then click on Unpivot Columns, 

 

 

Then you can go to report page, add a line chart visual, put the Attribute column in Axis bucket and Value to Values bucket. Add a matrix visual, drag the Label column to Rows, Attribute column to Columns bucket and Value to Values bucket. 

 

 

 

Best Regards,
Qiuyun Yu