Forum Discussion
Bar graphs
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
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
1 Reply
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