Filter by company and show all filter selection related sector companies in a chart

[auppala]

Hi,

I have a requirement to show list of all companies, based on a company filter selection (passed via URL filter. Different sector companies can be passed via URL filters)

Purpose is to show where a company stands in comparison to other companies in a particular sector.                       

For example: If i get the URL filter value as "Citi Bank" then i need to show in a chart all companies which come under "Citi Bank's" sector which is "Finance". Also the selected filter value Citi Bank should be highlighted amongst other finance companies to know where it stands against the rest. 

Please find the dataset format below.

Data 

Sector	Company	Yaxis	Xaxis
Finance	F1	22.4	200
Finance	F2	32.5	240
Finance	F3	20.5	300
Finance	F4	30.2	232
Finance	F5	19.5	234
Technology	T1	12.4	111
Technology	T2	33.2	121
Technology	T3	14	110

Regards

[v-juanli-msft · Accepted solution]

Hi @auppala 

Create a new table without any relationship:

select = SUMMARIZE('Table','Table'[cate],'Table'[Company ],'Table'[Sector])

Create measures and add to visual level filter, add measure to control conditional formatting

M-selected = CONCATENATEX(ALLSELECTED('select'),'select'[Sector],",")

M-flag = SEARCH(MAX('Table'[Sector]),[M-selected],1,0)

M-color = SEARCH(MAX('Table'[Company ]),CONCATENATEX(ALLSELECTED('select'),'select'[Company ],","),1,0)

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-juanli-msft]

Hi @auppala 

Where is the "Citi Bank" ? is it a value from a column?

Which relationship is between this "Citi Bank" and the current data table?

It seems possible with power bi desktop using DAX function.

If it is only allowed to use power bi service using query string parameter, it may be difficult.

Best Regards

Maggie

[auppala]

Hi @v-juanli-msft ,

      I have quoted citi bank for explanation of the scenario as an example. I have copied sample dataset for reference. 

I need the implementation in desktop, can you please share logic on how can we acheive this. 

Thanks and Regards

[amitchandak]

@auppala ,what do mean by url here ?

https://docs.microsoft.com/en-us/power-bi/service-url-filters

[auppala]

Hi Amit,

what i meant by URL Filters was "Filter a report using query string parameters in the URL"

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters

Regards