Power BI Visulization Query

[shansakhi]

Hi All,
I am trying to build a report in Power BI, here I need your support to guide me how I can achieve the required visulization.

Here W1 is our comany.

Book1
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
3
4		Input				Output
5		Bus Route	Fare ($)	Bus Company		Bus Route	W1 (Our Company) Fare	Min (Lowest) Fare	% Lower than W1	Other Bus Company >>>>>> Lower to Higher fares excluding W1
6		BOM-DEL	20	W1 (Our Company)		BOM-DEL	20	14	-30%	F10 / 14	C5 / 25	A10 / 30
7		BOM-DEL	25	C5		BOM-BLR	22	20	-9%	H19 / 20	K1 / 25	E10 / 33	Y12 / 38	J25 / 48
8		BOM-DEL	14	F10
9		BOM-DEL	30	A10
10		BOM-BLR	28	W1 (Our Company)
11		BOM-BLR	33	E10
12		BOM-BLR	20	H19
13		BOM-BLR	38	Y12
14		BOM-BLR	48	J25
15		BOM-BLR	25	K1
16
Sheet1

Cell Formulas
Range	Formula
J6:J7	J6	=I6/H6-1

Regards,

 

[AlienSx]

for the sake of simplicity I loaded your table into Power Pivot and wrote these simple measures (I am not good at DAX at all - sorry in advance for bad DAX coding)

W1_fare:=CALCULATE(MAX(Table1[Fare ($)]), Table1[Bus Company] = "W1")

min_fare:=MIN(Table1[Fare ($)])

lower_%:=DIVIDE([min_fare], [W1_fare]) - 1

lower_to_higher:=
VAR tbl = FILTER(Table1, Table1[Bus Company] <> "W1")
RETURN
    CONCATENATEX(
        tbl,
        Table1[Bus Company] & " / " & Table1[Fare ($)],
        " | ",
        Table1[Fare ($)],
        ASC
    )