List all Values Within a Column that Belong to a Value in Another Column

[datapal04]

I work for a transit agency and I'm looking to get the share of ridership for a station relative to the corridor it belongs to.

I have 4 columns: ori_station, des_station, corridor, ridership. Multiple ori_station belong to a Corridor, and there are multiple Corridors.

My report page has a slicer based on ori_station so that the user can select a station. I want bar chart that will list all ori_station that belong to the Corridor of the user-selected ori_station. The bar chart should also include the ridership # of each ori_station.

There is also an ori_station that appears in all Corridors and I'd like to not include this specific ori_station.

How can I achieve this?

[Ashish_Mathur]

Hi,

I have solved a similar question in the attached PBI file.

Hope this helps.

[datapal04]

I tried doing the same procedure you did by creating a seperate table for ori_station and using that for the slicer selection. While also having MAX function for Corridor... but this still does not work 😞

[v-priyankata]

Hi @datapal04 

Thank you for reaching out to the Microsoft Fabric Forum Community.
Can you please share sample data, so we can look into it & will try to provide the solution.

Thanks.

[v-priyankata]

Hi @datapal04 

Thank you for reaching out to the Microsoft Fabric Forum Community.

If you can share some sample data, we'll take a closer look and suggest a resolution.
Thanks.

[v-priyankata]

Hi @datapal04 
I hope everything is going well on your side. We haven't received a response from you yet. If the issue still persists, please share the sample data. If you have any other concerns, feel free to reach out to the community.

[parry2k]

@datapal04 this is something I showed in this video, take a look and tweak the solution as you see fit, it will get you started.

How to override slicer selection to return all records | PeryTUS - Power BI How To

[datapal04]

Thanks for this. But I'm still confused on how this will work because I need the ori_stations split so that I can calculate ridership for each.