Forum Discussion
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?
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
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")
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
Hi Anonymous ,
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