Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Need help in report building - Line chart

Hi Power BI Folks,

 

I would appricate if any provide help on below requirement.

I have data in spreadsheet download it here 

pbix attached here Download 

 

Measure formuale:-

Measure =
VAR _LProduct = CALCULATE(COUNT('Table2'[Availability]),'Table2'[Availability]IN {"Y","N"})
VAR _IProudct = CALCULATE(COUNT('Table2'[Availability]),'Table2'[Availability] IN {"Y"})
VAR _TotalCount =CALCULATE(COUNT('Table2'[Availability]),'Table2'[Availability] in {"Y","N","D"})

VAR _LP =DIVIDE(_LProduct,_TotalCount)*10
VAR _RP=DIVIDE(_IProudct,_TotalCount)*10
VAR _Total = (_LP+_RP)/100

RETURN
_Total

 

Output you see in pbix:- 

 

The goal is comparing Mfg A vs Others 3 top mfgs in line chart.  (No matter what value Mfg A had, it should appear be line chart.)

I'm trying to figure out a way to achieve a line chart that works like below.

 

 

Thanks in advance

 

 



1 Reply

  • VijayP's avatar
    VijayP
    Icon for Community Champion rankCommunity Champion

    Anonymous 

    Use Stacked Area chart by making the transparent solid so you can get the second result!