Forum Discussion
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
Community Champion
Anonymous
Use Stacked Area chart by making the transparent solid so you can get the second result!