Bar graphs

Gflood — Wed, 31 Jul 2024 16:54:44 GMT

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

Re: Bar graphs

Anonymous — Thu, 01 Aug 2024 02:05:31 GMT

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

topic Re: Bar graphs in Developer

Bar graphs

Re: Bar graphs