Bar graphs

[Gflood]

I am looking to basically combine two bar graphs. I want to show the diference before and after a major change. This involves comparing data by day. So I want to show the difference between the same days of the week from two different weeks side by side in a bar graph. When I add multiple dates that are the same day of the week, the data is just compbined. Is there a way to get them to show side by side?

Thank you

[Anonymous · Accepted solution]

Hi  @Gflood ,

I created some data:

Here are the steps you can follow：

1. Create calculated table.

Table 2 =
DISTINCT('Table'[Date])

2. Create measure.

Flag =
var _select=
SELECTCOLUMNS('Table 2',"selectdate",'Table 2'[Date])
var _column1=
ADDCOLUMNS( _select,"mindate",MINX(FILTER(ALL('Table'),'Table'[Weeknum]=WEEKNUM(EARLIER([selectdate]),2)-1&&'Table'[Weekday]=WEEKDAY(EARLIER([selectdate]),2)),[Date]),
"maxdate",MINX(FILTER(ALL('Table'),'Table'[Weeknum]=WEEKNUM(EARLIER([selectdate]),2)+1&&'Table'[Weekday]=WEEKDAY(EARLIER([selectdate]),2)),[Date]))
return
IF(
    MAX('Table'[Date]) in _select   ||
    MAX('Table'[Date]) in SELECTCOLUMNS(_column1,"mindate",[mindate]) ||
    MAX('Table'[Date]) in SELECTCOLUMNS(_column1,"maxdate",[maxdate]),1,0)

3. Place [Flag]in Filters, set is=1, apply filter.

4. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly