Problem when visualizing in line and clustered column chart

[SalimTRABELSI]

Hi everyone,

I have a list of airplanes incidents

I'm trying to make a visual that contains the number of impacts monthly with a line or an area that shows the existence of mowing so I tried with the line and clustered column chart but I'm stuck since power bi count the number of yes and no also the count distinct function does not give me the desired chart 

what I want in the visual is that if there's a mowing (yes) the line's up if no it's down

Do you have any suggestions?

[v-yangliu-msft]

Hi  @SalimTRABELSI ,

Here are the steps you can follow：

1. Create calculated column.

count_group =
COUNTX(FILTER(ALL('Table'),MONTH('Table'[Date])=MONTH(EARLIER('Table'[Date]))),[Id])

Flag =
IF(
    'Table'[moving]="no",0,
MAXX(ALL('Table'),[count_group]))

2. Placed in Visual, both set to Max.

3. Result:

If you need pbix, please click here.

Problem when visualizing in line and clustered column chart.pbix

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

[SalimTRABELSI]

Hi @v-yangliu-msft 

I followed the steps but I didn't get the same result as you!

Let me know if there is any problem

thank you,

Salim

[PVO3 · Accepted solution]

Hi,

A bit hard to understand.

I think you need or 2 lines, OR a single line that displays the balace between the 2 OR only the 'Line 1' measure below.

You can start by trying:

Line 1 = CALCULATE(COUNTROWS( 'Table'),  'Table'[Mowing] = "Yes")

Line 2 = CALCULATE(COUNTROWS( 'Table'),  'Table'[Mowing] = "No")

OR

Balance =

CALCULATE(COUNTROWS( 'Table'),  'Table'[Mowing] = "Yes") - 

CALCULATE(COUNTROWS( 'Table'),  'Table'[Mowing] = "No")

[SalimTRABELSI]

Hi @PVO3 

it might fix the problem but it's not well presented here's the result I get

what I trying to do is make one continuous line chart that increases if the value of mowing=yes and maintains 0 if mowing=no