Forum Discussion

zallebban's avatar
zallebban
Frequent Visitor
8 years ago

Comparing historical average to current week average

  I have been experimenting with Power BI and can handle most simple visualizations, but this one is beyond my skill.  I've researched the archives and have not found quite the same scenario.   Cu...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi zallebban,

 

Please share a dummy sample of the original data. Because the sample you post doesn't contain the date column. Besides, there seems no such visual. How about the Line and clustered column visual?

 

Best Regards,

Dale

zallebban's avatar
zallebban
Frequent Visitor
8 years ago

Dale, I think that visual would work.

 

This should do it.  My post preview is showing the empty QC columns, but they are disappearing when I post.  For demonstration purposes, feel free to reduce the number of quality attribute columns (prefixed by "QC") to make things easier.  If necessary, I can send an Excel export if you provide an email address.  Thanks.

 

Zayd

 

 

Date InitiatedName of CommuniquéQuality ScoreQC: Aligns w/TemplateQC: ClarityQC: CohesionQC: CompletenessQC: ConsistencyQC: ContentQC: DateQC: Draft LabelQC: FormattingQC: Spelling/Grammar

7/14/17Communiqué 183Yes  Yes  NoYesYesYes
7/20/17Communiqué 250Yes  No  NoYesYesNo
7/25/17Communiqué 317No  No  NoNoYesNo
7/26/17Communiqué 4100Yes  Yes  YesYesYesYes
7/26/17Communiqué 567Yes  Yes  YesYesNoNo
7/27/17Communiqué 667Yes  Yes  NoYesYesNo
7/31/17Communiqué 767Yes  Yes  NoYesNoYes
8/8/17Communiqué 8100Yes  Yes  YesYesYesYes
8/20/17Communiqué 983Yes  Yes  YesYesYesNo
8/22/17Communiqué 1083Yes  Yes  YesNoYesYes
8/30/17Communiqué 11100Yes  Yes  YesYesYesYes
9/14/17Communiqué 12100Yes  Yes  YesYesYesYes
9/14/17Communiqué 1367No  Yes  YesNoYesYes
9/19/17Communiqué 1433No  No  YesNoNoYes
9/26/17Communiqué 15100Yes  Yes  YesYesYesYes
10/9/17Communiqué 16           
10/12/17Communiqué 1783Yes  Yes  NoYesYesYes
10/17/17Communiqué 1867Yes  Yes  NoNoYesYes
10/19/17Communiqué 1983Yes  Yes  YesNoYesYes
11/14/17Communiqué 2050No  Yes  NoNoYesYes
11/27/17Communiqué 21100Yes  Yes  YesYesYesYes
1/6/18Communiqué 2283Yes  Yes  NoYesYesYes
1/8/18Communiqué 2367Yes  Yes  NoNoYesYes
1/12/18Communiqué 2467No  Yes  YesNoYesYes
1/22/18Communiqué 25           
2/6/18Communiqué 26100Yes  Yes  YesYesYesYes
2/8/18Communiqué 27100Yes  Yes  YesYesYesYes
2/19/18Communiqué 28100Yes  Yes  YesYesYesYes
2/27/18Communiqué 29100Yes  Yes  YesYesYesYes
2/27/18Communiqué 30100Yes  Yes  YesYesYesYes
3/5/18Communiqué 31100Yes  Yes  YesYesYesYes
3/6/18Communiqué 3267Yes  Yes  NoNoYesYes
3/13/18Communiqué 3383Yes  Yes  NoYesYesYes
4/2/18Communiqué 34100Yes  Yes  YesYesYesYes