cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## 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 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?

1 ACCEPTED SOLUTION
Impactful Individual

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

4 REPLIES 4
Community Support

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:

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

Frequent Visitor

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

Impactful Individual

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

Frequent Visitor

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors