Forum Discussion
Solved
Right chart for using bars, lines, and area
Good afternoon, folks.
I need to create a chart that on the X Axis has a calendar, and on the Y Axis some information:
- 2 bars that would be quantities in the month, with legend (Inlet and Output);
- 1 Line with Accumulated Input only;
- And here my difficulty, I need to highlight 2 (or more) months, as these are important;
Here is an example of what I would like to have in PowerBI:
Please, can you suggest to me how to achieve my goal?
I tried in PBI, one dot can't generate shadow.
here is a workaround for you .
create a new column
Column =var _x=maxx(FILTER('Table','Table'[Date]=EARLIER('Table'[Date])-1 ),'Table'[important])var _x2=maxx(FILTER('Table','Table'[Date]=EARLIER('Table'[Date])+1 ),'Table'[important])return if(_x="x"||'Table'[important]="x"||_x2="x","x")pls see the attachment below
2 Replies
You can try using a combo chart with reference lines. Reference lines were enhanced last month and might meet your requirements
I tried in PBI, one dot can't generate shadow.
here is a workaround for you .
create a new column
Column =var _x=maxx(FILTER('Table','Table'[Date]=EARLIER('Table'[Date])-1 ),'Table'[important])var _x2=maxx(FILTER('Table','Table'[Date]=EARLIER('Table'[Date])+1 ),'Table'[important])return if(_x="x"||'Table'[important]="x"||_x2="x","x")pls see the attachment below
