Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Problem when visualizing in line and clustered column chart

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 tri...
Need Help
  • PVO3's avatar
    PVO3
    4 years ago

    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")

     

     

PVO3's avatar
PVO3
Impactful Individual
4 years ago

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")

 

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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